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

149 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
suites6372740(None) 
sites56045431s_ites
skites104418041skites
smites83921921smites
spites84127331spites
suite54829561suite_
suited74019421suited
suiter64121811suiter
suiters73618881suiters
suits55028051suit_s
ascites9312602ascites
augites8312182augites
axites134913832axites
bites75641172_bites
blites84721212blites
boites84322702boites
butes714535872bu_tes
buttes84822562buttes
cites74435592_cites
curites93919862curites
cutes79438322cu_tes
cuties84927362cuties
dites66339152_dites
duits65021882duit_s
dunites8313592dunites
duties74921902duties
elites66027122elites
equites162212492equites
evites94916472evites
flites95122442flites
frites94922482frites
gites65630182_gites
guides84118282guides
guiles73919282guiles
guises74216312guises
gunites8313122gunites
juices1549422juices
jutes125125132ju_tes
kites95432542_kites
lucites9311862lucites
lutes55836662lu_tes
mites75141802_mites
mutes75033782mu_tes
nites55736342_nites
quiets154014372quiets
quintes164114712quintes
quires154015752quires
quite144621462quite_
quits144122352quit_s
quotes153312462quotes
rites54442552_rites
saices84221802saices
samites93118712samites
sates54949322s_ates
sautes63924912sautes
scutes85219192scutes
seines65029902seines
seises64026712seises
seizes154317532seizes
shies86136552shi_es
shines95028912shines
shires95225572shires
shits84731172shit_s
shives124921412shives
shotes95321912shotes
shutes93518222shutes
sices75637272s_ices
sides65838362s_ides
sikes96236082s_ikes
sines55954822s_ines
sipes76036952s_ipes
sires55945372s_ires
sises55233832s_ises
site47052412s_ite_
sited65130742s_ited
sits45050202s_it_s
situs55019232s_itus
sixes124526362s_ixes
sixtes133612402sixtes
sizes146727762s_izes
skates104219402skates
skies95026832ski_es
skite95120052skite_
skited114313482skited
skits94721862skit_s
skives134113942skives
slates64934062slates
slices84022852slices
slides73922182slides
slimes84722042slimes
slipes84921412slipes
slits56128852slit_s
sluices959072sluices
smiles84522292smiles
smite75224872smite_
smiter83616412smiter
smiters93414362smiters
smiths114711022smiths
snipes83917392snipes
snits54124832snit_s
somites94219122somites
sopites93817172sopites
sorites73825242sorites
spates85028172spates
spices104326032spices
spies76037622spi_es
spikes124520712spikes
spiles84227912spiles
spines85132032spines
spires84628112spires
spite75430662spite_
spited94820442spited
spits74429552spit_s
spitzes1849182spitzes
sprites94220332sprites
squires163812842squires
states64337082states
sties55132982sti_es
stiles64328772stiles
stimes85920572stimes
stipes84524052stipes
subitem1138552subitem
subitems1245492subitems
subsites10312782subsites
subtest9513962subtest
sucres84218892sucres
sudses74114502sudses
suedes73918112suedes
sues46247652su__es
suets55126102suet_s
suints64617782suints
suit45649872suit__
suitor63311052suitor
suitors73012492suitors
sulfites1139902sulfites
supes75628302su_pes
supines94216382supines
surges73924592surges
susses64221052susses
suttas63813792suttas
suttee63721542suttee
suttees74114062suttees
swipes114114332swipes
swives123915182swives
unites65024852unites
utes45930882_u_tes
whites123919882whites
wites85536962_wites
writes94420332writes

Search took 4 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 Filter178691825510.343520965.0
2DLD Change Limit825511492.70330540.5
3Display Results1491490.0334515.2
 (SQL Overall)1786911493.07958035.4
 
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.