Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “lippening” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

95 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
lippening1423494(None) 
lippering14217881lippering
happening1735592happening
kippering18205442kippering
lappering14258842lappering
lichening1545672lichening
likening13246892li_kening
lipping123016072lipp__ing
listening10128952listening
livening12248152li_vening
loppering14237282loppering
ripening1138572ri_pening
zippering23215202zippering
aliening91510893ali__ening
appending1536283_appending
blipping15306803blipp__ing
chippering2045163chippering
ciphering17217703ciphering
clipping15349153clipp__ing
coppering162810893coppering
crispening1543873crispening
dampening1535463dampening
deepening1335613deepening
diapering1339033diapering
dipping134014833dipp__ing
dispending1547923dispending
dispensing1448233dispensing
dizening19177143di_zening
flipping16307663flipp__ing
gipping133813123gipp__ing
glistening1294283glistening
happenings1842623happenings
hipping153915103hipp__ing
hyphening2144133hyphening
impeding1436563_impeding
impending1535933_impending
imponing1338773_imponing
kipping163311873kipp__ing
kittening1434593kittening
ladening1078823l_adening
lapping124117023lapp__ing
latening9711493l_atening
leadening1176733leadening
leavening1365973leavening
lessening1045333lessening
libeling1139873li_beling
licencing1443853li_cencing
licensing1244753li_censing
lichenin1345053lichenin_
lichenins1444843lichenins
lightening15255053lightening
lightning14286023lightning
limbering1488793limbering
limning103710323li__mning
limping124614113limp__ing
lingering11310513lingering
lining74526803li___ning
lippen103911403lippe__n_
lippened13255223lippen_ed
lippens11328533lippe__ns
lippings13296093lipp__ings
lipreading1444043lipreading
lisping103412753lisp__ing
littering102411983littering
livering122012383li_vering
loosening1044933loosening
lopping123815223lopp__ing
loudening1144743loudening
mildening1345673mildening
mispenning1545773mispenning
nipping123412873nipp__ing
opening1039923__opening
peening103318303__peening
peppering1337083peppering
pinkening1634993pinkening
pipping113414743pipp__ing
plumpening1742443plumpening
rappeling1435963rappeling
reopening1248823reopening
richening1546223richening
ripping123315743ripp__ing
rippling13197573ripp_ling
sickening1635993sickening
simpering1449293simpering
siphoning1546133siphoning
sipping123117433sipp__ing
skippering1943673skippering
slickening1743903slickening
slipping133510663slipp__ing
tipping122814973tipp__ing
tippling13196703tipp_ling
widening13237833wi_dening
wizening21255463wi_zening
yipping152710683yipp__ing
zipping212910573zipp__ing

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911486410.420425454.8
2DLD Change Limit148641956.95321378.0
3Display Results95950.0462065.2
 (SQL Overall)178691957.41924085.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.