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

182 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
hoorahs1339961(None) 
hookahs17446661hookahs
hoorah124411111hoorah_
hoorays13418381hoorays
horahs126313871h_orahs
coprahs14338152coprahs
dhooras1135942dhoora_s
dourahs11487252dourahs
goorals838712goorals
hijrahs2043442hijrahs
hookah16488242hookah_
hookas135312502hooka_s
hoorahed1545092hoorahed
hooray123011372hoora_y
horah117922052h_orah_
horas86333102h_ora_s
houdahs1434242houdahs
howdahs1733612howdahs
hurrahs13336772hurrahs
loofahs13364622loofahs
moolahs12347382moolahs
torahs95115642_torahs
agoras7613343agora_s
anoraks1137603anoraks
boorish123712593boorish
boors74325013boor__s
booths115313793boo_ths
borals86721913_borals
boras75938303_bora_s
chlorals13148033chlorals
chorals124614113chorals
cobras104014193cobra_s
coolths1236013coolths
coprah133710603coprah_
copras103517153copra_s
corals85325143_corals
corrals93713853corrals
dhoora1035653dhoora__
dobras94811913dobra_s
doodads1035093doodads
doormats1145413doormats
doors65022133door__s
doorways1544043doorways
dourah10479813dourah_
douras75016723doura_s
florals104210063florals
floras94715693flora_s
forams115115913_forams
forays124813003_forays
fourths13374953fourths
gerahs1039413_gerahs
goombahs1642523goombahs
gooral7310463goora_l
gorals76917653_gorals
haftorahs18133463haftorahs
hahs108333363h___ahs
hallahs133912463hallahs
halvahs16417533halvahs
hamzahs24134373hamzahs
harass9313943h_arass
hearths135311073hearths
hijrah1934283hijrah_
hijras1635773hijra_s
hoards104912623hoar_ds
hoars85925553h_o_ars
hodads1147963h_odads
hoers85724923hoer__s
hogans105914313h_ogans
hogwash1742713hogwash
holards1148433holards
hollas94616903holla_s
holograms1547373holograms
holographs1979983holographs
homographs21710553homographs
honans94814503h_onans
hondas10313353honda_s
honorand1246333honorand
honorands1345023honorands
honorary1445803honorary
honorees1148783honorees
honorers1139273honorers
honors94816793honor__s
hooch135813703hoo_ch_
hooches153812523hooches
hoodies113419833hoodies
hoodoos11109293hoodoos
hoods95124083hoo__ds
hooeys125512323hoo_eys
hoofers134513333hoofers
hoofs115721043hoo__fs
hooka125513903hooka__
hookers144916523hookers
hookeys17448963hookeys
hookies144017443hookies
hooks125027123hoo__ks
hookups1633273hookups
hoopers123616493hoopers
hooplas1239213hooplas
hoopoes121212483hoopoes
hoopoos1298543hoopoos
hoops105621073hoo__ps
hoorahing1644913hoorahing
hoorayed1544013hoorayed
hootch14386413hootch_
hootches1656973hootches
hooters104520483hooters
hoots84830253hoo__ts
hoovers134312713hoovers
hooves124815493hoo_ves
hora76136563h_ora__
horal86328683h_ora_l
horary12310383h_orary
hordes104921633h_ordes
horns86125333h_or_ns
horrors1078693horrors
horses94729353h_orses
horsts95817513h_orsts
hostas94515833hosta_s
hotrods1148283hotrods
houdah1335173houdah_
houris94514583hour_is
hours85422393hour__s
howdah1634723howdah_
hoyas115016163h_oya_s
huppahs1743333huppahs
hurrah12369183hurrah_
hurrays13386153hurrays
huzzahs2143083huzzahs
hydras13239313hydra_s
ixoras1337193ixora_s
jarrahs1735453jarrahs
jorams154810533_jorams
koras95927113_kora_s
korats105416063_korats
loofah12375813loofah_
loofas9429833loofa_s
lorans65117603_lorans
lotahs9479873_lotahs
menorahs1346543menorahs
mollahs12328283mollahs
moolah11409193moolah_
moolas83615593moola_s
moorage1038743moorage
moorages1139053moorages
moorish123311783moorish
moors74923143moor__s
morals85324643_morals
moras76438783_mora_s
morass84614503_morass
morays114613883_morays
morphs13149433_morphs
norths96812323_norths
obeahs1135863_obeahs
odahs95610083__odahs
okras94410973_okra_s
oohs75220693_oo__hs
oompahs1434263oompahs
oomphs1344723_oomphs
oorali6311263_oorali
ooralis7312553_ooralis
opahs105411983__opahs
orals55826483__orals
pooftahs1642363pooftahs
poohs103915713poo__hs
pooris83916843poor_is
poorish123712303poorish
rhodoras1244453rhodora_s
roorbachs1662563roorbachs
shorans102812413shorans
sirrahs10377303sirrahs
sooths95715593soo_ths
soras55041013_sora_s
sovrans1036483sovrans
surahs94515543_surahs
tooths96013803too_ths
torah87125273_torah_
toras55540373_tora_s
woorali1045263woorali
wooralis1145803wooralis
woorari1044633woorari
wooraris1145063wooraris
worths127812893_worths

Search took 7 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 Filter1786911340270.410435831.7
2DLD Change Limit1340271826.25021444.3
3Display Results1821820.0603033.3
 (SQL Overall)1786911826.72026590.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.