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

149 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
howdah163472(None) 
houdah1335171houdah
howdahs1733611howdahs
hodad10311352ho_dad
honda9414982honda_
hondas10313352hondas
hookah16488242hookah
hoorah124411112hoorah
horah117922052ho_rah
houdahs1434242houdahs
howdie13349732howdie
howdy155711412howd_y
odah87018932_o_dah
aoudad835043aoudad
bowman13129853bowman
chordal13449883chordal
chowder16387813chowder
chuddah17263253chuddah
coda77029343co_da_
codas84724243co_das
coprah133710603coprah
cowman13910373cowman
cowpat13312033cowpat
dah78148983___dah
doodad936423doodad
dourah10479813dourah
dowdy136112543dowd_y
goddam1145163goddam
gowan95415743gow_an
gowd96519983gowd__
gowds105814043gowd_s
hadal95518123h_adal
hah910655223h___ah
hallah124115403hallah
halvah15499833halvah
hamzah23135563hamzah
handax1749583handax
heyday1635143heyday
hijrah1934283hijrah
hoar76729163ho__ar
hoax147718293ho__ax
hod76852463ho_d__
hodads1147963ho_dads
hodden113811453hodden
hoddin11369943hoddin
hods87239863ho_d_s
hoed87837983hoed__
hogan97817703ho_gan
hogwash1742713hogwash
hoiden103612333hoiden
hold86235063hold__
holdall1145473holdall
holden104113953holden
holder104619653holder
holds94623243hold_s
holdup1245183holdup
holiday1436143holiday
holla84918493holla_
hollas94616903hollas
holyday1743773holyday
honan85319773ho_nan
hondle103914523hondle
hooch135813703ho_och
hood85132333hood__
hooded114616743hooded
hoodie105116143hoodie
hoodoo10109983hoodoo
hoods95124083hood_s
hoody124919723hood_y
hooka125513903hooka_
hookahs17446653hookahs
hookas135312493hookas
hoorahs13399603hoorahs
hooray123011373hooray
hootch14386413hootch
hora76136563ho_ra_
horahs126313873ho_rahs
horal86328683ho_ral
horas86333103ho_ras
horde94623053hord_e
horded115420483horded
hordes104921633hordes
hosta85917833hosta_
hostas94515823hostas
hotch136214733ho_tch
hotdog1134803hotdog
how97252433how___
howdied15296843howdied
howdies142911953howdies
howe106734103how__e
howes114730263how_es
howf136127203how__f
howff175110493how_ff
howffs18535043howffs
howfs144814503how_fs
howk145221963how__k
howked177312343howked
howks155016853how_ks
howl107625693how__l
howled134014973howled
howler123514313howler
howlet123518343howlet
howls116219223how_ls
hows106345603how__s
hoya107418373ho_ya_
hoyas115016163ho_yas
hoyden13328933hoyden
huppah1644183huppah
hurrah12369183hurrah
huzzah2044423huzzah
hwan105716893h_w_an
hyoidal1444803hyoidal
jordan1468063jordan
jowar155211433jow_ar
keddah1534263keddah
khedah1743643khedah
loofah12375813loofah
lotah85315853lo_tah
lowish12310533lowish
modal85919243mo_dal
mollah11319453mollah
moolah11409193moolah
nodal64717793no_dal
noway111112843now_ay
obeah1038993_obeah
oda48133043_o_da_
odahs95610083_o_dahs
odas57230263_o_das
oompah1334253oompah
opah96218403_o_pah
pardah123412823pardah
powder123611903powder
purdah12288753purdah
rowan85418733row_an
rowdy125711533rowd_y
rowth115713233row_th
showman15257293showman
soda56329383so_da_
sodas64123543so_das
soldan73511853soldan
soudan73210353soudan
sowar85821343sow_ar
sowcar1135863sowcar
today96416953to_day
torah87125273to_rah
towpath1544043towpath
whidah1634803whidah
whydah1942953whydah
yodh119916103yo_d_h

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.376475242.0
2DLD Change Limit1127161494.62324381.6
3Display Results1491490.0334515.2
 (SQL Overall)1786911495.03235510.9
 
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.