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 “gifts” 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.

145 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
gifts9621496(None) 
gift86735791gift_
gilts64924261gilts
girts65423621girts
gists66026191gists
gits55744591gi_ts
grifts104511681grifts
lifts85719061lifts
rifts85718641rifts
sifts84918921sifts
agists75713172agists
airts55626342airts
aits46355532ai_ts
biffs134814412biffs
bints76130182bints
bits66148162bi_ts
bitts75022592bitts
cists76624532cists
clifts11519152clifts
diets66026642diets
diffs126315482diffs
difs86027322dif_s
dints67431312dints
dirts66824462dirts
dits56450522di_ts
drifts10499892drifts
efts76519482_efts
fiats85324482fiats
fifes114822392fifes
fifth145210922fifth
fifths15406542fifths
fifty145211422fifty
fists85527542fists
fits76043462fi_ts
gaffs124914652gaffs
gaits65726012gaits
gasts66628632gasts
gats56753442g_ats
gelts65924612gelts
gents65729612gents
gests66028812gests
gets55442482g_ets
ghats95818612ghats
giants74713502giants
gibes84422522gibes
gibs75529272gi_bs
gids65933742gi_ds
gies55641422gi_es
gifted114510702gifted
giftee103512082giftee
giftees11306512giftees
gigas75415582gigas
gigots83911952gigots
gigs66631182gi_gs
gilds75417522gilds
gills64728192gills
gilt56348542gilt_
gimps105915202gimps
ginks104319562ginks
gins55543952gi_ns
gips75632922gi_ps
girds74816992girds
girls64518392girls
girns64516802girns
giros65722652giros
girt56646422girt_
girth95618842girth
girths105612272girths
gist56046762gist_
git46266052gi_t_
gite55438612gi_te
gites65630182gites
gives95324872gives
gliffs13436322gliffs
glints75714212glints
gluts66120132gluts
gnats65217712gnats
goats65527302goats
gouts64826172gouts
grafts105013252grafts
griffs13398992griffs
grift95924462grift_
griots74713642griots
grists74716482grists
grits65529582grits
grots65025852grots
guffs124414822guffs
guilts74111232guilts
gusts65722792gusts
guts56637252g_uts
hafts116219462hafts
hefts116218152hefts
hilts86924412hilts
hints87330622hints
hists86328372hists
hits75545132hi_ts
ifs67124242_if_s
its35538832_i_ts
jiffs185710312jiffs
jilts124717412jilts
kifs116023512kif_s
kilts95122182kilts
kists95822112kists
kits86441772ki_ts
lefts86517812lefts
lift76942722lift_
lilts55822802lilts
lints57137192lints
lists56628692lists
lits46252492li_ts
lofts85518362lofts
miffs134512882miffs
milts75430712milts
mints76834042mints
mists76633902mists
mitts75523752mitts
nifty115211632nifty
nits45741642ni_ts
pints75936222pints
pits66348742pi_ts
rafts87820632rafts
riffs115114612riffs
rifs74929002rif_s
rift75642332rift_
riots54922012riots
shifts124412942shifts
sift710740662sift_
silts55330822silts
sits45050202si_ts
softs85019232softs
swifts12408172swifts
tiffs114414882tiffs
tilts55325612tilts
tints56030922tints
tits46145042ti_ts
tofts84919242tofts
tufts85713272tufts
wafts116920552wafts
wefts116715492wefts
wifes114522562wifes
wifty144212092wifty
wilts85023502wilts
wists86728522wists
wits76044872wi_ts
zits136030292zi_ts

Search took 2 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.296603685.8
2DLD Change Limit538001451.54634799.5
3Display Results1451450.0463152.2
 (SQL Overall)1786911451.88894645.7
 
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.