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

196 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
sifts8491892(None) 
gifts96214961gifts
lifts85719061lifts
rifts85718641rifts
shifts124412931shifts
sift710740661sift_
silts55330821silts
sits45050201si_ts
softs85019231softs
swifts12408171swifts
airts55626342airts
aits46355532ai_ts
biffs134814402biffs
bints76130182bints
bits66148152bi_ts
bitts75022592bitts
cists76624532cists
clifts11519152clifts
diets66026642diets
diffs126315482diffs
difs86027322dif_s
dints67431312dints
dirts66824462dirts
dits56450522di_ts
drifts10499892drifts
efts76519482_efts
fiats85324482fiats
fifes114822392fifes
fifth145210922fifth
fifths15406542fifths
fifty145211422fifty
fists85527542fists
fits76043462fi_ts
gift86735792gift_
gilts64924262gilts
girts65423622girts
gists66026192gists
gits55744592gi_ts
grifts104511682grifts
hafts116219462hafts
hefts116218152hefts
hilts86924412hilts
hints87330622hints
hists86328372hists
hits75545132hi_ts
ifs67124242_if_s
its35538832_i_ts
jiffs185710312jiffs
jilts124717412jilts
kifs116023502kif_s
kilts95122182kilts
kists95822112kists
kits86441762ki_ts
lefts86517812lefts
lift76942722lift_
lilts55822802lilts
lints57137192lints
lists56628692lists
lits46252492li_ts
lofts85518362lofts
miffs134512872miffs
milts75430712milts
mints76834042mints
mists76633902mists
mitts75523752mitts
nifty115211632nifty
nits45741642ni_ts
pints75936222pints
pits66348742pi_ts
rafts87820632rafts
resifts10378702resifts
riffs115114612riffs
rifs74929002rif_s
rift75642332rift_
riots54922012riots
safes85226722safes
saints65122422saints
salts55431882salts
scats75930602scats
scots74025902scots
scuts74522522scuts
seats54844342seats
sects75622892sects
seifs85019332seif_s
septs75420602septs
sets45549502s_ets
setts55124322setts
sexts125118382sexts
shafts125411432shafts
shift114225132shift_
shifty15409252shifty
shirts94918332shirts
shists96515102shists
shits84731162shits
shots84730832shots
shrifts1335962shrifts
shuts85622472shuts
sials54227242sials
sibbs96211892sibbs
sibs65933532si_bs
sices75637272sices
sicks115127622sicks
sics65234092si_cs
sides65838362sides
sifted104313672sifted
sifter94516232sifter
sifters103714782sifters
sighs95416742sighs
sights103818012sights
signs65516322signs
sikas94617022sikas
sikes96236082sikes
silds65520522silds
silks94620682silks
sills55135982sills
silos56029422silos
silt46558192silt_
silty84721632silty
simas75727552simas
simps94719762simps
sims65737172si_ms
sines55954822sines
sings65532702sings
sinhs86719602sinhs
sinks95529182sinks
sins46755272si_ns
sinus55523852sinus
sipes76036952sipes
sips65740102si_ps
sires55945372sires
sirs44338332si_rs
sis37360542si__s
sises55233832sises
sit35877752si_t_
site47052412si_te
sites56045432sites
sith75435152si_th
situs55019232situs
sixes124526362sixes
sixte126216582sixte
sixtes133612402sixtes
sixth155512232sixth
sixths16416372sixths
sixty154912732sixty
sizes146727762sizes
skats94621532skats
skiffs16327012skiffs
skirts104111502skirts
skits94721852skits
slats55436902slats
slits56128852slits
slots54830522slots
sluts54523982sluts
smuts75415712smuts
sniffs12378842sniffs
snits54124832snits
snots55225102snots
sofas85320712sofas
soft76942822soft_
softa86415182softa
softas94410402softas
softy115414482softy
soots55536202soots
sorts54536662sorts
sots45552442s_ots
spats75031382spats
spiffs14328472spiffs
spirts85317132spirts
spits74429552spits
spots74424102spots
stats55933362stats
stets55423912stets
stiffs12389962stiffs
stilts67915302stilts
stints65119762stints
stots54828542stots
suets55126102suets
suints64617782suints
suits55028052suits
swats85726862swats
swift116818052swift_
swots85518422swots
tiffs114414882tiffs
tilts55325612tilts
tints56030922tints
tits46145032ti_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.0931921408.6
2DLD Change Limit538001961.44037361.1
3Display Results1961960.0464260.9
 (SQL Overall)1786911961.579113167.2
 
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.