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

270 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
gizmos184413(None) 
gismos957181gismos
gizmo1756011gizmo_
gazoos163010222gazoos
gimmes113010902gimmes
gimps105915202gi_mps
giros65722652gi_ros
gismo848862gismo_
limos75320812li_mos
sixmos1534812sixmos
agios65919863agi__os
agisms9399393agism_s
aims67738183ai_m_s
alamos8415003alamos
ammos94815823_ammos
bazoos173212623bazoos
bigos85020013bi_gos
bilbos105011203bilbos
bimas95521743bi_mas
bimbos124610523bimbos
bingos95514793bingos
biomes103815253biomes
bios66335323bi__os
biros75325133bi_ros
bizes165923663biz_es
bizzes163910843bizzes
bozos165216863boz_os
bromos104213313bromos
camos95927613_camos
chemos13311723chemos
ciscos104711133ciscos
cosmos10311753cosmos
demos86022993_demos
didos76820813di_dos
dildos8179303dildos
dimes85833043di_mes
dims75435023di_m_s
dinos65428063di_nos
dipsos95310053dipsos
discos94915213discos
dismes95617673dismes
dittos74111973dittos
dizens164911393dizens
duomos936823duomos
eidos65817753ei_dos
fidos95819053fi_dos
fillos94415083fillos
filmis114610283filmis
films105617963film_s
filos86125383fi_los
finos86226953fi_nos
firms105217423firm_s
fizzes174512553fizzes
gamas85431363g_amas
gambs105721123g_ambs
games86238553g_ames
gammas115714693gammas
gammon1138903gammon
gammons1237973gammons
gamps105323713g_amps
gams76648883g_am_s
gaums86217073gaum_s
gazabos1944453gazabos
gazars164811553gazars
gazebos1933493gazebos
gazers164516303gazers
gazes155425913gaz_es
gazoo153112873gaz_oo
gazumps2131873gazumps
geckos13457433geckos
gemot84024233g_emot
gemots93712153g_emots
gems75329113g_em_s
genoms94412483genoms
genros74211333genros
germs85118873germ_s
geums85414113geum_s
giants74713503giants
gibbon1135323gibbon
gibbons1234983gibbons
gibbose1244083gibbose
gibbous1265333gibbous
gibers95114663gibers
gibes84422523gi_bes
gibs75529273gi__bs
gibson935123gibson
gibsons1045043gibsons
gids65933743gi__ds
gies55641423gi__es
gifts96214963gi_fts
gigas75415583gi_gas
giglot84013133giglot
giglots9367863giglots
gigolos934693gigolos
gigot74023073gi_got
gigots83911953gigots
gigs66631183gi__gs
gigues8129003gigues
gilds75417523gi_lds
gills64728193gi_lls
gilts64924263gi_lts
gimel8313353gi_mel
gimels938893gimels
gimmal11247513gimmal
gimmals12225823gimmals
gimme102411343gi_mme
gimmie11298183gimmie
gimmies123010113gimmies
gimp96124043gi_m_p
gimpy135212233gi_mpy
gingkos13405343gingkos
ginkgos13314183ginkgos
ginks104319563gi_nks
gins55543953gi__ns
ginzo1539613ginzo_
ginzoes1735433ginzoes
gipon84212413gi_pon
gipons9389603gipons
gips75632923gi__ps
girds74816993gi_rds
girls64518393gi_rls
girns64516803gi_rns
giro55828633gi_ro_
giron66118993gi_ron
girons75014373girons
girths105612273girths
girts65423623gi_rts
gists66026193gi_sts
gitanos837173gitanos
gites65630183gi_tes
gits55744593gi__ts
givens10379733givens
givers104817713givers
gives95324873gi_ves
glamor958193glamor
glamors1068123glamors
glams85822933glam_s
glimes94717523glimes
glims87417673glim_s
gliomas1035333gliomas
gloms85219783glom_s
glomus9468093glomus
glooms96211683glooms
glumes94516813glumes
glums84621423glum_s
gnomes93812973gnomes
gnomon936183gnomon
gnomons1035753gnomons
gobos86219383g_obos
gogos77516523g_ogos
gombos114311093gombos
goos57644913g__oos
gorms85619593gorm_s
gos47155133g___os
gramas94317203gramas
gramps114114273gramps
grams85327313gram_s
gregos847533gregos
grimes94619033grimes
gringos936673gringos
grooms94512523grooms
grumes94415553grumes
grumose1035723grumose
grumous1086613grumous
grumps114510573grumps
guacos94410313guacos
guanos73811993guanos
guiros7389093guiros
gumbos114610873gumbos
gummas114810513gummas
gummose1235333gummose
gummous1236263gummous
gums75030943g_um_s
gyms107514593g_ym_s
gyros95616483g_yros
hillos94618893hillos
hims95230973hi_m_s
hippos13408433hippos
hommos13128503hommos
homos105921783_homos
iambs95815063_iambs
igloos738033igloos
imps86221123_i_mps
infos84311673_infos
inmost8411363_inmost
isms66213473_ism_s
izars145112933_izars
jisms14458003jism_s
kazoos19259113kazoos
kiddos12416863kiddos
kilos95021473ki_los
kinos96626143ki_nos
lidos65219883li_dos
lilos55821873li_los
limas75627633li_mas
limbos104712143limbos
limbs96118943li_mbs
limes75636503li_mes
limns75718393li_mns
limo65529733li_mo_
limps95522673li_mps
linos55631503li_nos
lithos94212553lithos
litmus836323litmus
memos95719113_memos
mezzos1635053mezzos
micros104115363micros
midmost1246153midmost
mikvos1554023mikvos
milos75428013mi_los
mimeos104511543mimeos
mimes95732023mi_mes
mimosa1036363mi_mosa
misos76523293mi_sos
mizens174610253mizens
mos57067123___mos
mozos165516333moz_os
nims66226883ni_m_s
nitros64214123nitros
nizams1735413nizams
nomos75919743_nomos
orzos143311253orz_os
ouzos143210413ouz_os
pianos84315933pianos
pimas94725103pi_mas
pimps114616983pi_mps
pingos95317673pingos
pinkos125313873pinkos
pintos86021293pintos
piscos105112593piscos
pisos76021063pi_sos
pizzas1646983pizzas
pomos95321583_pomos
primos104514423primos
promos105116423promos
rimes75634543ri_mes
rimose8310593ri_mose
rimous8311913ri_mous
rims65936303ri_m_s
schmos13379153schmos
shamos114216983shamos
sickos125112033sickos
siglos7311473siglos
sigmas94111363sigmas
silos56029433si_los
simas75727553si_mas
simps94719763si_mps
sims65737173si_m_s
sixmo1448303sixmo_
sizars154812623sizars
sizers155215813sizers
sizes146727763siz_es
skimos12548803skimos
sumos75720093_sumos
times75630823ti_mes
tiros54524893ti_ros
videos104911373videos
vims95423313vi_m_s
vinos84723073vi_nos
vireos94212453vireos
vizirs18306713vizirs
vizor173010093viz_or
vizors18328903vizors
wazoos18288553wazoos
wimps125213803wi_mps
winos84625043wi_nos
wizens186110263wizens
wizes174723343wiz_es
wizzes175110773wizzes
zoos135828803__zoos

Search took 6 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 Filter1786911127160.393454684.5
2DLD Change Limit1127162704.60624471.6
3Display Results2702700.0962812.5
 (SQL Overall)1786912705.09535071.8
 
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.