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

273 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
moolah1140919(None) 
mollah11319451mollah
moola75117031moola_
moolahs12347381moolahs
moolas83615591moolas
coolth1139512coolth
hookah16488242hookah
hoorah124411112hoorah
loofah12375812loofah
mola66035632m_ola_
molal75120342m_olal
molar75223092m_olar
molas75132092m_olas
mollahs12328282mollahs
moloch1356482moloch
mooch125313612moo_ch
mool67533862mool__
mooley11311632mooley
mools76027172mool_s
mullah113710732mullah
blah98625063__blah
bola66035563_bola_
bolar75123473_bolar
bolas74733763_bolas
booth105522013boo_th
boyla102912363boyla_
boylas113011723boylas
chalah143511663chalah
chola104718033chola_
cholas114818003cholas
coala77521123coala_
coalas87418963coalas
cola66541393_cola_
colas75436773_colas
collar83816173collar
cooch124916833coo_ch
cool66940493cool__
coolant9316463coolant
cooled95224593cooled
cooler84824713cooler
coolie83821603coolie
coolish12312523coolish
coolly114811393coolly
cools75632633cool_s
coolths1236013coolths
cooly105525423cool_y
coprah133710603coprah
dobla84913643dobla_
doblas93812293doblas
dollar74110983dollar
doodad936423doodad
doolee73018953doolee
doolie73916833doolie
dooly94821803dool_y
doula65717773doula_
doulas75114993doulas
dourah10479813dourah
fellah124910773fellah
fool75330593fool__
fooled104317823fooled
foolish1339613foolish
fools86824203fool_s
galah95917643_galah
golosh1036463golosh
goombah1543113goombah
gooral7310463gooral
goulash1164273goulash
hallah124115403hallah
holla84918493holla_
hollas94616903hollas
hooch135813703hoo_ch
hooka125513903hooka_
hookahs17446663hookahs
hookas135312503hookas
hoolie93217783hoolie
hooly115022223hool_y
hoopla1147633hoopla_
hooplas1239213hooplas
hoorahs13399613hoorahs
hooray123011373hooray
hootch14386413hootch
horah117922053_horah
houdah1335173houdah
howdah1634723howdah
keblah1545313keblah
kiblah1535583kiblah
koala95112213koala_
koalas104011663koalas
kola85124973_kola_
kolas94822233_kolas
loofa85912813loofa_
loofahs13364623loofahs
loofas9429833loofas
lotah85315853_lotah
malar76424443m_alar
matsah1138233matsah
matzah2035963matzah
medlar93010463medlar
menorah1247933menorah
mikvah18143473mikvah
milch124413373m_ilch
mislay113510683mislay
moa57249183m_o_a_
moan65832023m_o_an
moas65545343m_o_as
moat66352033m_o_at
mobcap1444113mobcap
mobled113213183mobled
mocha1249923mocha_
mochas13310663mochas
modal85919243m_odal
modals93914463modals
modish123813543modish
modular1087363modular
moil65534093moil__
moiled94318863moiled
moiler84017263moiler
moils76125753moil_s
moira71012023moira_
moirai886913moirai
mol56654593m_ol__
molars85517323m_olars
mold76034333m_ol_d
molds85324833m_olds
moldy115014653m_oldy
mole66251833m_ol_e
moles74747923m_oles
moll66735703m_ol_l
mollie83517103mollie
molls75129783m_olls
molly105222493m_olly
molochs1435223molochs
mols65948573m_ol_s
molt66356163m_ol_t
molto75619603m_olto
molts76032093m_olts
moly96031913m_ol_y
momma85111053momma_
mommas94110653mommas
monad85519473m_onad
monas74732153m_onas
monish114217603monish
monolith1349673monolith
monolog10259353monolog
month104818423m_onth
moo58460513moo___
mood76332063moo__d
moods85224623moo_ds
moody115017493moo_dy
mooed85123983moo_ed
mooing93718373mooing
mooleys1236863mooleys
moon67140813moo__n
mooned94216643mooned
mooner85317833mooner
moonish123311043moonish
moonlet92413273moonlet
moonlit9229333moonlit
moons75331003moo_ns
moony104818273moo_ny
moor66628553moo__r
moorage1038743moorage
moored93814173moored
moorish123311783moorish
moorland1144683moorland
moors74923143moo_rs
moory105115793moo_ry
moos66051303moo__s
moose76327193moo_se
moot67653623moo__t
mooted94120373mooted
mooter83921093mooter
moots75831663moo_ts
mopish134311593mopish
mora66641273m_ora_
morae75831193m_orae
moral75533433m_oral
morale85220553morale
morals85324643morals
moras76438783m_oras
moray105423793m_oray
morgan9311373morgan
morph121712513m_orph
mortal84616853mortal
mortar83812043mortar
morula8710473morula_
morulae958963morulae
morular978223morular
morulas959723morulas
mosh95227603m_o_sh
moshav1446053moshav
moth96731333m_o_th
motley1139383motley
mouch124715803m_ouch
moulage1037903moulage
mould86015753moul_d
moulds94910993moulds
mouldy12437413mouldy
moulin8313283moulin
moult74728723moul_t
moults84713703moults
mouth105420293m_outh
moviola1244823moviola_
moviolas1344513moviolas
moxa136917743m_oxa_
moxas145014403m_oxas
mulch124012973m_ulch
mulla74317113mulla_
mullahs12388733mullahs
mullas84215933mullas
mylar105311533m_ylar
mynah13569563m_ynah
myoma1239273myoma_
myomas1338303myomas
nullah9388143nullah
obeah1038993_obeah
odah87018933__odah
olla44821173_olla_
ollas54218283_ollas
onlay84212943_onlay
ooh67637093_oo__h
oolith93813243_oolith
oompah1334253oompah
oomph1236973_oomph
opah96218403__opah
polar75623453_polar
pooch124815303poo_ch
pooftah1543143pooftah
pooh96027383poo__h
pool65835953pool__
pooled94619813pooled
pooler83819843pooler
pools74427703pool_s
poplar103611113poplar
potlach14106363potlach
prolan8414693prolan
selah8319613_selah
smooch13266803smoo_ch
smoosh11236733smoo_sh
smooth11259203smoo_th
sola45541863_sola_
solan55328153_solan
solar55927343_solar
sooth85924063soo_th
tola45236333_tola_
tolan55124013_tolan
tolar55524113_tolar
tolas54532773_tolas
tool46735683tool__
toolbar944773toolbar
tooled74918903tooled
tooler63818613tooler
tools55325243tool_s
tooth88020183too_th
torah87125273_torah
viola85915543viola_
violas93713523violas
voila84813943voila_
volar86917413_volar
wallah124011993wallah
wool76427373wool__
wooled103715503wooled
woolen93111373woolen
wooler93615873wooler
woolhat1346043woolhat
woolie93514483woolie
woolly12408513woolly
woolman1235433woolman
wools84421463wool_s
wooly114417673wool_y
woosh113710733woo_sh
zillah1836563zillah
zoonal1558083zoonal

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 Limit1127162735.28021347.7
3Display Results2732730.0803412.5
 (SQL Overall)1786912735.73631152.5
 
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.