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

183 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
homos10592179(None) 
hobos106321351hobos
homes106938821homes
hommos13128501hommos
homo96126471homo_
nomos75919741nomos
pomos95321581pomos
ammos94815822ammos
bohos105618252bohos
bolos75531372bolos
bombs115818822bombs
booms95427122booms
boos67955032bo_os
boyos105418282boyos
bozos165216862bozos
bromos104213312bromos
camos95927612camos
chemos13311722chemos
cholos114716852cholos
chomps155112222chomps
chromos142610272chromos
cocos95624692cocos
cohos105921852cohos
comas95833002comas
combos125316612combos
combs116122962combs
comes97246992comes
comose105016852comose
comous10816512comous
compos124818802compos
comps115526052comps
coos67456492co_os
cosmos10311752cosmos
demos86022992demos
dodos75819392dodos
dojos135111792dojos
domes85735562domes
doms76239572dom_s
dooms85321342dooms
duomos936822duomos
gobos86219382gobos
gogos77516522gogos
gombos114311092gombos
goos57644912go_os
halos85230252halos
hames106138702hames
hams96446132ham_s
helos84928062helos
hemes105031082hemes
hemps126917332hemps
hems95534942hem_s
heros84930862heros
hims95230972him_s
hoars85925552hoars
hobo97026082hobo_
hoboes114717452hoboes
hobs97038982ho_bs
hocks144925492hocks
hocus104715202hocus
hods87239862ho_ds
hoers85724922hoers
hoes75755732ho_es
hoggs107212462hoggs
hogs87139662ho_gs
hokes126231642hokes
holds94623242holds
holes84748652holes
holks124720562holks
hollos95320632hollos
holms105117802holms
hols76946292ho_ls
holts85627912holts
home98042442hom_e
homed115425422homed
homer105828452homer
homers114821982homers
homey135924842homey
homeys145012882homeys
homie104622532homie
homies114524732homies
homosex1936132homosex
homy126623222hom_y
hones88144492hones
hongs95126202hongs
honks125124522honks
honor85718622honor
honors94816792honors
hons77350782ho_ns
hood85132332ho_od
hoods95124082hoods
hoof106036582ho_of
hoofs115721042hoofs
hook116133282ho_ok
hooks125027122hooks
hoop96129982ho_op
hoops105621072hoops
hoot75752102ho_ot
hoots84830252hoots
hopes105835642hopes
hops97942632ho_ps
horas86333102horas
horns86125332horns
hos68364192h__os
hoses85443182hoses
hosts85526702hosts
hots78349332ho_ts
hours85422392hours
howes114730262howes
howfs144814502howfs
howks155016852howks
howls116219222howls
hows106345602ho_ws
hoyas115016162hoyas
hoys107733932ho_ys
humor101110512humor
humors11129632humors
humps126322802humps
hums96831422hum_s
humus106215072humus
hymns1337522hymns
hypos1312014742hypos
jomon14610082jomon
kobos115616892kobos
kolos94921212kolos
kotos95717702kotos
limos75320812limos
lobos75921842lobos
locos75822602locos
logos67225332logos
looms75124642looms
loos49051122lo_os
lotos54724632lotos
memos95719112memos
mojos145314462mojos
momes95134472momes
moms86539482mom_s
momus96116112momus
monos75930862monos
moos66051302mo_os
mos57067122__mos
mozos165516332mozos
nolos54423352nolos
nomas74726412nomas
nomes74933122nomes
nomoi76012532nomoi
noms65636402nom_s
ohms95514032ohm_s
oms56337512_om_s
onos46229002_onos
phonos114114792phonos
photos113316642photos
polos76129912polos
pomes94833932pomes
pomo85828452pomo_
pomps115316192pomps
poms87037742pom_s
poos65949112po_os
promos105116422promos
rhombs13336492rhombs
romeos84013172romeos
romps94617542romps
roms67038962rom_s
rooms75324682rooms
rotos56027882rotos
shamos114216982shamos
shoos84226362sho_os
solos54830792solos
somas76030372somas
soms66239372som_s
sumos75720092sumos
tholos94213002tholos
tombs97818732tombs
tomes76037382tomes
toms68343492tom_s
topos75726392topos
toros54336192toros
toyos87519142toyos
whomps16457602whomps
whomso1434132whomso
wombs125813342wombs
woos76238802wo_os
zooms164415522zooms
zoos135828802zo_os

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 Filter178691538000.310576422.6
2DLD Change Limit538001831.61033416.1
3Display Results1831830.0503660.0
 (SQL Overall)1786911831.97090706.1
 
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.