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 “zizit” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

354 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
zizit1331327(None) 
zizith1744821zizith
binit76431582binit
digit73825272digit
dixit134420592dixit
fixit154819302fixit
licit74327682licit
limit73126342limit
pipit95224872pipit
tzitzit1542692tzitzit
visit8320962visit
vizir17359392vizir
zibet16419732zibet
zit126049992__zit
ziti136022372ziti_
zitis145815582zitis
zuzim1534862zuzim
adit56443653_adit
admit8319493admit
afrit8323173afrit
airt45757783ai_rt
ait38093903__ait
alit46155693_alit
ambit94223713ambit
audit62527883audit
await85524493await
bait66556003_bait
befit105222663befit
bezil163812883bezil
bidet84935623bidet
bidi78226573bidi_
bidis86721143bidis
bifid11910703bifid
bight118728843bight
bigot84828323bigot
bikie113915883bikie
binits85716673binits
bint67355043bi_nt
biont7727163biont
bit57070903__bit
bitt65545813bi_tt
biz147939363biz__
bize155926293biz_e
bizes165923663bizes
brit66350153_brit
bruit76126723bruit
chit96937463_chit
cilia73016763cilia
cist67244963ci_st
civet105828733civet
civic123412543civic
civie103716353civie
civil103411933civil
cozie163519123cozie
crit65743713_crit
cubit94122893cubit
davit93424593davit
debit85727853debit
demit84832303demit
diazin1639163diazin
dicot85429093dicot
didie74120563didie
didst74619613didst
diet57357533di_et
dight104027003dight
digits84114533digits
dimity12310473dimity
dimwit1237953dimwit
dint56759053di_nt
dipt77339323di_pt
dirt55550383di_rt
dit47071333__dit
divot95723073divot
dixits144210313dixits
dizen155214933dizen
dizzy177410853dizzy
doit56347853_doit
droit65127123droit
duit56241583_duit
edit54934863_edit
eight94928053eight
elicit8417203elicit
emit65438423_emit
exit114428673_exit
fiat76646643fi_at
ficin103516723ficin
fight124027093fight
filet85540163filet
finis86824263finis
finite9316823finite
finito9310303finito
first86226123first
fist76248423fi_st
fit66365453__fit
fixity19427803fixity
fixt1410729713fi_xt
fiz156238763fiz__
fizgig2032973fizgig
fizz157519823fiz_z
fizzy199015083fizzy
flit76539273_flit
frit77044473_frit
fruit85122223fruit
fuzil173810703fuzil
gait56150193_gait
giant65430593giant
gift86735793gi_ft
gigot74023073gigot
gilt56348543gi_lt
girt56646423gi_rt
gist56046763gi_st
git46266053__git
gizmo1756013gizmo
grit55247243_grit
habit103027023habit
hight125327233hight
hili75626633hili_
hilt75850713hi_lt
hint77455743hi_nt
hist76551543hi_st
hit66569193__hit
ibis66519583_ibis
idiot6718863_idiot
ikat87626643_ikat
ilia46026823_ilia
imid76122293_imid
inia45024703_inia
inti46626083_inti
irid55927173_irid
iris45732553_iris
it28455683___it
iwis77117013_iwis
ixia115713213_ixia
izar136616013_izar
jilt115839423ji_lt
kainit10414483kainit
kibitz2177643kibitz
kilim11711883kilim
kilt86144413ki_lt
kinin94917323kinin
kist86540793ki_st
kit78559873__kit
kiwi113211793kiwi_
kiwis12328583kiwis
knit85728143_knit
krait94726773krait
legit61323503legit
licht104723493licht
lift76942723li_ft
light94429603light
lilt46349943li_lt
limits82514143limits
linin58025523linin
lint416266233li_nt
lipid85916173lipid
lipin75518893lipin
liri45128253liri_
lirot5430033lirot
list47055343li_st
lit39377313__lit
livid96714423livid
merit7339183merit
midi75628473midi_
midis85923413midis
midst85922553midst
might113827083might
milia72719573milia
milt65455813mi_lt
mimic111414323mimic
mini65634553mini_
minim97321603minim
minis75432993minis
mint66758053mi_nt
miri66730373miri_
mirin75023153mirin
misfit112813833misfit
mishit112618193mishit
mislit83019693mislit
mist66154533mi_st
mitis75425993mitis
mitt66145493mi_tt
mixt136831923mi_xt
mizen164815273mizen
nazi136219873nazi_
nazis145216083nazis
nidi56524393nidi_
night94327853night
nihil8410283nihil
nisi45823243nisi_
nit37065943__nit
nitid61817833nitid
nitwit938593nitwit
nixie125114943nixie
nizam16310253nizam
obit66837083_obit
oidia6314953oidia
omit65337373_omit
orbit73622063orbit
petit74332653petit
pewit104622793pewit
picot95031013picot
piki106520563piki_
pikis115116393pikis
pili66130353pili_
pilis75825203pilis
pilot77435063pilot
pinite8321243pinite
pinot78737293pinot
pint66963173pi_nt
pipet95533323pipet
pipits104713063pipits
pit56471923__pit
pivot106523873pivot
pixie145415523pixie
pizza1538183pizza
plait75631573plait
posit75833333posit
qiviut1846613qiviut
qubit164218993qubit
quit136136513_quit
quoit143819863quoit
recit75235103recit
refit84230063refit
relit55340683relit
remit75737223remit
resit54241043resit
riant55833153riant
ricin74620213ricin
rift75642333ri_ft
right94430503right
rigid7913893rigid
riot45947213ri_ot
rivet85636363rivet
seizin153610843seizin
shit76745933_shit
sift710740663si_ft
sight94629293sight
sigil63515503sigil
silt46558193si_lt
sit35877753__sit
sizar145214993sizar
size135630963siz_e
sized155519243sized
sizer145521813sizer
sizes146727763sizes
sizier1514813393sizier
siziest16311473siziest
sizing163616443sizing
sizy164816393siz_y
skit85437523_skit
slit46250103_slit
smit65138413_smit
snit46342473_snit
sozin14514523sozin
spait75631603spait
spirit83519923spirit
spit65545083_spit
split75729013split
sprit76736403sprit
suit45649873_suit
tacit76333673tacit
tibia7312403tibia
tidbit938493tidbit
tight93626503tight
tiki87620843tiki_
tikis95615973tikis
tilt46252423ti_lt
timid84815723timid
tinct76126233tinct
tint46758863ti_nt
tipi69924433tipi_
tipis76019923tipis
tit36771043__tit
titbit839823titbit
titi47130613titi_
titis56023813titis
tizzy16548893tizzy
toit46353063_toit
trait56940843trait
twilit949553twilit
twit76329063_twit
tzitzis1542413tzitzis
tzitzith1951863tzitzith
unfit84518563unfit
unit45140073_unit
unlit55025463unlit
unwit84417523unwit
unzip16207623unzip
uplit76020803uplit
vibist11610583vibist
vigia94813273vigia
vigil94313003vigil
vinic10314973vinic
virid94116043virid
visits9311423visits
vivid125112313vivid
vizier184311023vizier
vizirs18306713vizirs
vizor173010093vizor
vomit102622573vomit
wait75553693_wait
whit104834173_whit
wight123725573wight
wilt76246293wi_lt
wist78049293wi_st
wit66563773__wit
wiz156434153wiz__
wizen175813863wizen
wizes174723343wizes
writ75537913_writ
zamia165115213zamia
zayin174512043zayin
zazen1337283zazen
zein135620603z_ein
zenith1839073zenith
zest136035703z_est
zibeth2034173zibeth
zibets1737743zibets
zig136931903__zig
zigs145422793zi_gs
zigzag1642963zigzag
zilch19438123zilch
zill135727613zi_ll
zills144020783zills
zin125643773__zin
zinc156819093zi_nc
zincic1935903zincic
zincite1837233zincite
zincs165312933zincs
zincy195413513zincy
zine137036153zi_ne
zineb165614143zineb
zines145232653zines
zing145728613zi_ng
zings154620893zings
zingy186516133zingy
zinky215314813zinky
zinnia1536013zinnia
zins135735003zi_ns
zip146636223__zip
zippy21518743zippy
zips155723793zi_ps
ziram163912893ziram
zits136030293zi_ts
zizzle13247313zizzle
zoic152316073z_oic
zoisite1635833zoisite
zooid15312103zooid
zori137722923zori_
zoril143916693zoril
zoris145320013zoris
zowie174313843zowie
zuz1110622033zuz__
zzz1017911913z_z_z

Search took 8 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 Filter178691836670.233766914.2
2DLD Change Limit836673546.58012715.3
3Display Results3543540.0933806.5
 (SQL Overall)1786913546.90625874.7
 
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.