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 “lifts” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

160 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
lifts8571906(None) 
clifts11519151clifts
gifts96214961gifts
lefts86517811lefts
lift76942721lift_
lilts55822801lilts
lints57137191lints
lists56628691lists
lits46252491li_ts
lofts85518361lofts
rifts85718641rifts
sifts84918921sifts
airts55626342airts
aits46355532ai_ts
alifs86121262alif_s
biffs134814412biffs
bints76130182bints
bits66148162bi_ts
bitts75022592bitts
cists76624532cists
clefts114610162clefts
cliffs14477592cliffs
clift106422192clift_
diets66026642diets
diffs126315482diffs
difs86027322dif_s
dints67431312dints
dirts66824462dirts
dits56450522di_ts
drifts10499892drifts
efts76519482_efts
elints65816422elints
fiats85324482fiats
fifes114822392fifes
fifth145210922fifth
fifths15406542fifths
fifty145211422fifty
fists85527542fists
fits76043462fi_ts
flints95617452flints
flirts95411482flirts
flits85625222fli_ts
gift86735792gift_
gilts64924262gilts
girts65423622girts
gists66026192gists
gits55744592gi_ts
gliffs13436322gliffs
glints75714212glints
grifts104511682grifts
hafts116219462hafts
hefts116218152hefts
hilts86924412hilts
hints87330622hints
hists86328372hists
hits75545132hi_ts
ifs67124242_if_s
its35538832_i_ts
jiffs185710312jiffs
jilts124717412jilts
kifs116023502kif_s
kilts95122182kilts
kists95822112kists
kits86441762ki_ts
lasts57731262lasts
lats45962702l_ats
leets54927122leets
left76340482left_
lefty115613562lefty
lets47147942l_ets
liars54723162liars
libs66732762li_bs
lichts113712382lichts
licks115325392licks
lidos65219882lidos
lids56336452li_ds
liens56525502liens
liers55130402liers
lies46454192li_es
lieus56218482lieus
life75433732lif_e
lifer85822152lifer
lifers95617842lifers
lifted104413522lifted
lifter93814812lifter
lifters104313782lifters
lights104519912lights
likes96231902likes
lilos55821872lilos
lilt46349942lilt_
limas75627632limas
limbs96118942limbs
limes75636502limes
limits82514142limits
limns75718392limns
limos75320812limos
limps95522672limps
lines57054572lines
lings67135772lings
links96430192links
linns56123332linns
linos55631502linos
lins47059052li_ns
lint416266232lint_
linty87126562linty
lions55923212lions
lips67141442li_ps
liras56021982liras
lis37162272li__s
lisps76913902lisps
list47055342list_
lit39377312li_t_
litas54923772litas
lite47054542li_te
litu47631562li_tu
lives86133192lives
loft76539142loft_
lofty115813302lofty
loots55431422loots
lots47652092l_ots
louts56330272louts
luffs114516282luffs
lunts55826902lunts
lusts55022802lusts
miffs134512882miffs
milts75430712milts
mints76834042mints
mists76633902mists
mitts75523752mitts
nifty115211632nifty
nits45741642ni_ts
pints75936222pints
pits66348742pi_ts
rafts87820632rafts
riffs115114612riffs
rifs74929002rif_s
rift75642332rift_
riots54922012riots
shifts124412932shifts
sift710740662sift_
silts55330822silts
sits45050202si_ts
slits56128852sli_ts
softs85019232softs
swifts12408172swifts
tiffs114414882tiffs
tilts55325612tilts
tints56030922tints
tits46145032ti_ts
tofts84919242tofts
tufts85713272tufts
uplifts12424772uplifts
wafts116920552wafts
wefts116715492wefts
wifes114522562wifes
wifty144212092wifty
wilts85023502wilts
wists86728522wists
wits76044872wi_ts
zits136030292zi_ts

Search took 3 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 Filter178691538000.0762351197.4
2DLD Change Limit538001602.59320748.2
3Display Results1601600.233686.7
 (SQL Overall)1786911602.90261575.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.