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

179 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
moolahs1234738(None) 
mollahs12328281mollahs
moolah11409191moolah_
moolas83615591moola_s
coolths1236012coolths
hookahs17446662hookahs
hoorahs13399612hoorahs
loofahs13364622loofahs
molars85517322m_olars
molas75132092m_ola_s
mollah11319452mollah_
molochs1435222molochs
moola75117032moola__
mooleys1236862mooleys
mools76027172mool__s
mullahs12388732mullahs
blahs105616513__blahs
bolas74733763_bola_s
booths115313793boo_ths
boylas113011723boyla_s
chalahs15289883chalahs
cholas114818003chola_s
coalas87418963coala_s
colas75436773_cola_s
collars93816573collars
coolant9316463coolant
coolants1039943coolants
coolers93522493coolers
coolies93824963coolies
coolish12312523coolish
cools75632633cool__s
coolth1139513coolth_
coprahs14338153coprahs
doblas93812293dobla_s
dollars83311023dollars
doodads1035093doodads
doolees83711613doolees
doolies83920713doolies
doulas75114993doula_s
dourahs11487253dourahs
fellahs13428393fellahs
foolish1339613foolish
fools86824203fool__s
galahs105512683_galahs
goombahs1642523goombahs
goorals838713goorals
goulash1164273goulash
hallahs133912463hallahs
hollas94616903holla_s
hookah16488243hookah_
hookas135312503hooka_s
hooplas1239213hoopla_s
hoorah124411113hoorah_
hoorays13418383hoorays
horahs126313873_horahs
houdahs1434243houdahs
howdahs1733613howdahs
keblahs1634563keblahs
kiblahs1634153kiblahs
koalas104011663koala_s
kolas94822233_kola_s
loofah12375813loofah_
loofas9429833loofa_s
lotahs9479873_lotahs
malars85020683m_alars
matsahs1236563matsahs
matzahs2134483matzahs
medlars10259443medlars
menorahs1346543menorahs
mikvahs19162493mikvahs
mislays12349243mislays
moans74624373m_o_ans
moas65545343m_o_a_s
moats75827643m_o_ats
mobcaps1543463mobcaps
mochas13310663mocha_s
modals93914463m_odals
modulars1165833modulars
moilers93615203moilers
moils76125753moil__s
mola66035633m_ola__
molal75120343m_ola_l
molar75223093m_ola_r
molds85324833m_ol_ds
moles74747923m_ol_es
molies84429513m_olies
mollies93420233mollies
molls75129783m_ol_ls
moloch1356483moloch_
mols65948573m_ol__s
molts76032093m_ol_ts
mommas94110653momma_s
monads94515303m_onads
monas74732153m_ona_s
monoliths1445913monoliths
monologs112210533monologs
months113812933m_onths
mooch125313613moo_ch_
mooches143714453mooches
moods85224623moo__ds
mool67533863mool___
mooley11311633mool_ey
mooners94015343mooners
moonish123311043moonish
moonless10278043moonless
moonlets10247473moonlets
moons75331003moo__ns
moorage1038743moorage
moorages1139053moorages
moorish123311783moorish
moorland1144683moorland
moorlands1244203moorlands
moors74923143moo__rs
moos66051303moo___s
mooters93818623mooters
moots75831663moo__ts
morales93619403morales
morals85324643m_orals
moras76438783m_ora_s
morass84614503m_orass
morays114613883m_orays
morgans10310123morgans
morphs13149433m_orphs
mortals93914013mortals
mortars93411523mortars
morulas959723morula_s
moths106021553m_o_ths
motleys1235683motleys
moulage1037903moulage
moulages1138053moulages
moulds94910993moul_ds
moulins9312703moulins
moults84713703moul_ts
mouths115214533m_ouths
moviolas1344513moviola_s
moxas145014403m_oxa_s
mullah113710733mullah_
mullas84215933mulla_s
mylars114310443m_ylars
mynahs14416443m_ynahs
myomas1338303myoma_s
nullahs10316993nullahs
obeahs1135863_obeahs
odahs95610083__odahs
ollas54218283_olla_s
onlays9398713_onlays
oohs75220693_oo__hs
ooliths10268323_ooliths
oompahs1434263oompahs
oomphs1344723_oomphs
opahs105411983__opahs
polars84419353_polars
pooftahs1642363pooftahs
poohs103915713poo__hs
poolers94217423poolers
pools74427703pool__s
poplars113910333poplars
prolans9314273prolans
selahs9313213_selahs
smooths12216323smoo_ths
solans64122493_solans
sooths95715593soo_ths
tolans64319273_tolans
tolars64817943_tolars
tolas54532773_tola_s
toolbars1044743toolbars
toolers74416503toolers
tools55325243tool__s
tooths96013803too_ths
torahs95115643_torahs
violas93713523viola_s
wallahs13409473wallahs
woolens10398843woolens
woolers104214023woolers
woolhat1346043woolhat
woolhats1443593woolhats
woolies104117363woolies
wools84421463wool__s
zillahs1935383zillahs

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.453394461.4
2DLD Change Limit1340271796.15621771.8
3Display Results1791790.0762355.3
 (SQL Overall)1786911796.68526730.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.