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

159 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
suite5482956(None) 
quite144621461quite
site47052411s_ite
skite95120051skite
smite75224871smite
spite75430661spite
suit45649871suit_
suited74019421suited
suiter64121811suiter
suites63727401suites
suits55028051suits
augite7312612augite
axite125218252axite
bite66547002_bite
blite76225352blite
boite74426322boite
bute66739672bu_te
butte74924292butte
cite65640342_cite
curite85222942curite
cute66440452cu_te
cutie76925932cutie
dite55547552_dite
duit56241582duit_
duits65021882duits
dunite7315012dunite
elite56230182elite
evite85317682evite
flite85424962flite
gite55438612_gite
guide75019882guide
guile64521132guile
guise64717712guise
gunite7414402gunite
juice14311322juice
jute115327892ju_te
kite85338242_kite
lite47054542_lite
lucite8313342lucite
lute46341012lu_te
mite66249412_mite
mute65136872mu_te
nite45943582_nite
quate144521412quate
quiet144530732quiet
quinte153414522quinte
quire144917132quire
quit136136512quit_
quits144122352quits
quote143714772quote
rite45849452_rite
saice75424052saice
saith85826552saith
saithe94713912saithe
samite83020602samite
sate45556102s_ate
saute55028082saute
scute75520942scute
seine55732872seine
seise54727852seise
seize143819502seize
sente56432882sente
shine85533092shine
shire84727132shire
shit76745942shit_
shits84731172shits
shive114423422shive
shote85526102shote
shute84520352shute
sice65545592s_ice
side55444492s_ide
sike87138782s_ike
sine46560622s_ine
sipe67341042s_ipe
sire46150412s_ire
sit35877752s_it_
sited65130742s_ited
sites56045432s_ites
sith75435152s_ith
sits45050202s_its
sixte126216582sixte
size135630962s_ize
skate94721552skate
skit85437532skit_
skited114313482skited
skites104418042skites
skits94721862skits
skive124614112skive
slate55438282slate
slice74925822slice
slide64725412slide
slime74925752slime
slipe75626132slipe
slit46250102slit_
slits56128852slits
sluice849512sluice
smile74823922smile
smit65138412smit_
smiter83616412smiter
smites83921922smites
smith107818052smith
smote75820282smote
snide64318722snide
snipe75320572snipe
snit46342472snit_
snits54124832snits
somite84519372somite
sopite84917712sopite
spate74731582spate
spice95528812spice
spike114922842spike
spile75230082spile
spine76534422spine
spire75828692spire
spit65545082spit_
spited94820442spited
spites84127332spites
spits74429552spits
spitz166017972spitz
sprite84421772sprite
squire155912462squire
state56237332state
stile54931572stile
stime76521802stime
stipe76523372stipe
suave83519872suave
subitem1138552subitem
subito8410452subito
subsite9412872subsite
subtle82113432subtle
sucre75019102sucre
sue35651462su__e
suede64419752suede
suet46754822suet_
suets55126102suets
suety85318492suety
suing65026362suing
suint55638182suint
suints64617782suints
suiters73618882suiters
suitor63311052suitor
sulfite10310472sulfite
supe65932762su_pe
supine84216692supine
sure45447412su_re
surge65027692surge
sutta54015332sutta
suttee63721542suttee
swine85625302swine
swipe105217082swipe
swith115917402swith
swithe124010682swithe
swive115316192swive
trite54730032trite
unite54828382unite
ute35335882_u_te
white114920302white
wite75443272_wite
write85522832write

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.296603685.8
2DLD Change Limit538001591.81329674.6
3Display Results1591590.0463456.5
 (SQL Overall)1786911592.15582919.3
 
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.