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

215 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
whilom143613(None) 
hilum105514602_hilum
shalom11810922shalom
sholom11910112sholom
whelm134611982whel_m
while115418692whil_e
whiled134514132whiled
whiles124418012whiles
whilst1239142whilst
whim126220532whi__m
whitlow1642852whitlow
whom127018182wh__om
awhile1257793awhil_e
axiom143913593axi_om
bailor83412603bailor
celom9515693_celom
chalot113020133chalot
chiao105618363chiao_
chiasm13449103chiasm
chico124218253chico_
chicos134614833chicos
chigoe1237533chigoe
child114516223chil_d
childe124711213childe
chile105626893chil_e
chiles115425303chiles
chili106218483chil_i
chilis115517873chilis
chill105619873chil_l
chilli114312773chilli
chills114717703chills
chillum1435443chillum
chilly144113223chilly
chino105823313chino_
chinos115018693chinos
chirm125317063chi_rm
chiro105320343chiro_
chiros114617773chiros
chiton112612393chiton
cholo105217973cholo_
cholos114716853cholos
chrisom1466623chrisom
coelom10310433coelom
epilog976463epilog
film94828173_fil_m
filo76034283_filo_
filos86125383_filos
filum105015433_filum
glom75424383__glom
halm95834973_hal_m
halo76437323_halo_
halon86124863_halon
halos85230253_halos
helm95530023_hel_m
helo75332853_helo_
helos84928063_helos
helot85332683_helot
hila76228353_hil_a
hilar85418143_hilar
hili75626633_hil_i
hill76439493_hil_l
hillo84721653_hillo
hilloa94713033_hilloa
hillos94618893_hillos
hills85431353_hills
hilly114422163_hilly
hilt75850713_hil_t
hilts86924413_hilts
hilus84817643_hilus
him86247663_hi__m
holm95628113_hol_m
idiom899963idi_om
jailor13418573jailor
kilim11711893_kilim
kilo86028673_kilo_
kilos95021473_kilos
lilo46731563_lilo_
lilos55821873_lilos
milo65536103_milo_
milos75428013_milos
phenom1339473phenom
philomel1544083philomel
phloem1335713ph_loem
phlox1737333ph_lox
phylon14318033phylon
phylum1655153phylum
pilot77435063_pilot
rhino84614323rhino_
rhinos94411123rhinos
rhizoma2143283rhizoma
rhizome2143513rhizome
sailor63113753sailor
shaloms1288983shaloms
shill85325333shil_l
shills94519613shills
shily115222013shil_y
shim95827863shi__m
sholoms1278033sholoms
silo46037913_silo_
silos56029433_silos
slalom888173slalom
tailor63412503tailor
thill85918733thil_l
thills95515383thills
thio77225413thi_o_
thiol87616043thi_ol
thiols95112763thiols
thiram1139963thiram
tholoi9339233tholoi
tholos94213003tholos
wail75238823wail__
wailed104823593wailed
wailer93720323wailer
wails86631483wail_s
wailsome1344493wailsome
wallop113310293wallop
wallow123913513wallow
weblog1234223weblog
whale115517433whal_e
whaled134612033whaled
whaler124611973whaler
whales124716943whales
wham125321693wh__am
whammo16405193whammo
whamo135511263whamo_
whelk154311063whel_k
whelks16367323whelks
whelky19314973whelky
whelms14377573whelms
whelp136012093whel_p
whelps14437843whelps
which163910083whi_ch
whid115418873whi__d
whidah1634803whidah
whids125413983whi_ds
whiff17310063whi_ff
whiffs1835083whiffs
whig115516423whi__g
whigs125612643whi_gs
whiling143511743whiling
whims134515333whi_ms
whimsy17375223whimsy
whin105225693whi__n
whine116022813whi_ne
whined134715203whined
whiner124516633whiner
whines125120103whines
whiney155012643whiney
whinge134311543whinge
whinny15587493whinny
whins114922333whi_ns
whiny144915573whi_ny
whip125521843whi__p
whippy19385843whippy
whips134917083whi_ps
whipt135317423whi_pt
whipworm2142963whipworm
whir105519283whi__r
whirl114913823whi_rl
whirled14368043whirled
whirler13307603whirler
whirls124710533whirls
whirly15448863whirly
whirr114611193whi_rr
whirrs12408593whirrs
whirry15477063whirry
whirs115218093whi_rs
whish144512923whi_sh
whisht154510813whisht
whisk154510143whi_sk
whisks16497353whisks
whisky19455903whisky
whist115322953whi_st
whists124613813whists
whit104834173whi__t
white114920303whi_te
whited134814083whited
whiten124111923whiten
whiter124316393whiter
whites123919883whites
whitey154911883whitey
whitlows1743083whitlows
whits115923823whi_ts
whity145513473whi_ty
whiz195919943whi__z
whizz194210323whi_zz
whizzy23274073whizzy
who95526773wh__o_
whoa106615203wh__oa
whole114418093whol_e
wholes124616773wholes
wholism1535883wholism
wholly15366573wholly
whomp155011323wh__omp
whoof144612693wh_oof
whoop134211443wh_oop
whop125520923wh__op
whoso11509223whoso_
widow1278933w_idow
wilco1039443w_ilco
wild85126513w_il_d
wilds94818203w_ilds
wile75944373w_il_e
wiled95231553w_iled
wiles85437873w_iles
will75737513w_il_l
willow12369693willow
wills84528963w_ills
willy115321913w_illy
wilt76246293w_il_t
wilts85023503w_ilts
wily106428813w_il_y
wino75933613w_ino_
winos84625043w_inos
wisdom1235983wisdom

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.390458182.1
2DLD Change Limit1127162155.03322395.4
3Display Results2152150.0633412.7
 (SQL Overall)1786912155.48632572.2
 
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.