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

221 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
smit6513841(None) 
emit65438421emit
omit65337371omit
shit76745941shit
sit35877761s_it
skit85437541skit
slit46250101slit
smite75224871smite
smith107818051smith
smut66629781smut
snit46342471snit
spit65545081spit
suit45649871suit
adit56443662adit
admit8319492admit
ait38093912_ait
alit46155692alit
ambit94223712ambit
ami56646812ami_
amia66836902amia
amid77036362amid
amie66339852amie
amin66042252amin
amir65129752amir
amis66445322amis
amity10416092amity
bait66556002bait
bit57070912_bit
brit66350152brit
chit96937462chit
crit65743712crit
demit84832302demit
dit47071342_dit
doit56347852doit
duit56241582duit
edit54934872edit
emic86422752emic
emir65918702emir
emits75421472emits
exit114428672exit
fit66365462_fit
flit76539272flit
frit77044472frit
gait56150192gait
git46266062_git
grit55247242grit
hit66569202_hit
imid76122302imid
it28455692__it
kit78559892_kit
knit85728152knit
limit73126342limit
lit39377322_lit
mat58083942_mat
met56072432_met
mi48249062_mi_
mib76946132_mib
mic77647652_mic
mid67354482_mid
mig65646092_mig
mil55752122_mil
milt65455822_milt
mim76048432_mim
mint66758072_mint
mir57046782_mir
mis58162632_mis
mist66154542_mist
mite66249422_mite
mitt66145502_mitt
mity95528222_mity
mix126138192_mix
mixt136831932_mixt
mot57279422_mot
mut58357182_mut
nit37065952_nit
obit66837082obit
omits75018262omits
osmic939912osmic
pit56471932_pit
quit136136512quit
remit75737222remit
said55742122said
sail45447162sail
sain45551292sain
saint55147072saint
saith85826552saith
salt45758522salt
samite83020602samite
sat36288482s_at
sati45539332sati
scat65848372scat
scot66242612scot
scut65835542scut
seat47575562seat
sect67443622sect
sei36048932sei_
seif75638732seif
seis45542392seis
semi65127222semi_
semis74623532semis
sent46963012sent
sept65844362sept
set36681252s_et
sett45949052sett
sext117338092sext
shat76456602shat
shift114225142shift
shim95827862shim
shin75634312shin
ship95228242ship
shirt84533902shirt
shist84829612shist
shits84731172shits
shiv105721172shiv
shot76150262shot
shut76137592shut
si29149582s_i_
sib56850322s_ib
sic55847882s_ic
sift710740672sift
silt46558202silt
sim56553152s_im
sima64730792sima
simp85228782simp
sims65737182sims
sin36265902s_in
sip57656022s_ip
sir35746682s_ir
sis37360552s_is
site47052422s_ite
sith75435162s_ith
sits45050212s_its
six105339752s_ix
skat87037902skat
ski74925702ski_
skid95720942skid
skim105322522skim
skin85927542skin
skint95629232skint
skip105421762skip
skirt95624672skirt
skis84825302skis
skite95120062skite
skits94721872skits
slat46959022slat
slid55828992slid
slim66631962slim
slip67031732slip
slipt76627482slipt
slits56128852slits
slot46049832slot
slut45040592slut
smalt74729332smalt
smart75834092smart
smelt74726782smelt
smew95017732smew
smile74823922smile
smirk116612752smirk
smiter83616412smiter
smites83921922smites
smiths114711022smiths
smithy14508272smithy
smog76317412smog
smolt74824162smolt
smote75820282smote
smug75815262smug
smuts75415712smuts
snib66522982snib
snip66424652snip
snits54124832snits
snot44745452snot
soft76942822soft
soil46138832soil
somite84519372somite
soot45761062soot
sort46264812sort
sot310384302s_ot
spait75631602spait
spat66548522spat
spic85227432spic
spik105419712spik
spilt75532222spilt
spin66231302spin
spirt75032952spirt
spite75430662spite
spits74429552spits
spitz166017972spitz
spiv95917792spiv
split75729012split
spot65540692spot
sprit76736402sprit
sri35634002sri_
sris45434152sris
stat47352692stat
stet45947322stet
stilt54831982stilt
stint57037662stint
stir45723252stir
stot46347332stot
submit10312672submit
suet46754822suet
suint55638182suint
suite54829562suite
suits55028052suits
summit10311542summit
swat77244442swat
swift116818052swift
swig85818022swig
swim96221402swim
swith115917402swith
swot75134662swot
tit36771062_tit
toit46353062toit
twit76329062twit
unit45140072unit
vomit102622572vomit
wait75553692wait
whit104834172whit
wit66563782_wit
writ75537912writ
zit126050002_zit

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 Filter178691298720.280638182.1
2DLD Change Limit298722210.87634100.5
3Display Results2212210.0633507.9
 (SQL Overall)1786912211.219146588.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.