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

240 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
mollahs1232828(None) 
mollah11319451mollah_
moolahs12347381moolahs
mullahs12388731mullahs
collars93816572collars
dollars83311022dollars
fellahs13428392fellahs
hallahs133912462hallahs
hollas94616902holla_s
molars85517322mo_lars
molas75132092mo_la_s
mollies93420232mollies
molls75129782moll__s
molochs1435222molochs
moolah11409192moolah_
moolas83615592moola_s
mullah113710732mullah_
mullas84215932mulla_s
nullahs10316992nullahs
ollas54218282_olla_s
wallahs13409472wallahs
zillahs1935382zillahs
allays94313743_allays
almahs118611613_almahs
ballads104212913ballads
blahs105616513__blahs
bolas74733763bo_la_s
bollard103210503bollard
bollards11339153bollards
bolls75531313boll__s
boylas113011723boyla_s
callans94518473callans
callas84526753calla_s
cellars93713693cellars
chalahs15289883chalahs
challahs16377563challahs
chollas123811353cholla_s
coalas87418963coala_s
colas75436773co_la_s
coleads102911423coleads
collage102813763collage
collages113514243collages
collapse1244273collapse
collar83816173colla_r
collard103712923collard
collards113310193collards
collate92919683collate
collates103019143collates
collets93517903collets
collies94326583collies
collins93419833collins
collops112611753collops
colzas174010513colza_s
coolths1236013coolths
coprahs14338153coprahs
cullays12347703cullays
doblas93812293dobla_s
dollar74110983dolla_r
dollies83620983dollies
dollish11610093dollish
dollops10287963dollops
dolls66126923doll__s
dolmans10479683dolmans
dolmas95213043dolma_s
doulas75114993doula_s
dourahs11487253dourahs
eoliths10318573eoliths
fallals103310193fallals
fellah124910773fellah_
fellas95116963fella_s
folles93820473foll_es
follies103618943follies
follis93113903foll_is
follows13409923follows
fullams1236553fullams
galahs105512673_galahs
goliaths1244223goliaths
goulash1164273goulash
halalahs14367443halalahs
hallah124115403hallah_
halvahs16417533halvahs
holla84918493holla__
hollaed11359853hollaed
holland11349473holland
hollands12247273hollands
hollers103818233hollers
hollies103420813hollies
holloas103814943holloas
holloes103818193holloes
holloos104013583holloos
hollos95320633holl_os
hollows134412333hollows
hookahs17446653hookahs
hoorahs13399603hoorahs
horahs126313873ho_rahs
houdahs1434243houdahs
howdahs1733613howdahs
jollies143516273jollies
keblahs1634563keblahs
kiblahs1634153kiblahs
koalas104011663koala_s
kolas94822233ko_la_s
lallans74113533lallans
lollers72713793lollers
lollies73116923lollies
lollops9227443lollops
lolls512121733loll__s
loofahs13364623loofahs
lotahs9479873lo_tahs
malars85020683m_alars
mallard10310273mallard
mallards1138323mallards
mallees93315973mallees
mallets93318493mallets
malleus92911313malleus
mallows123714323mallows
malls76233433mall__s
malthas1237913malthas
matsahs1236563matsahs
matzahs2134483matzahs
medlars10259443medlars
megillahs1542233megillahs
mellows123812233mellows
mells75031333mell__s
mikvahs19162493mikvahs
millage103112753millage
millages113212903millages
milldams1344633milldams
millers93621343millers
milles84526563mill_es
millets94216843millets
mills75435053mill__s
milpas101710273milpa_s
mislays12349243mislays
moans74624373mo__ans
moas65545343mo__a_s
moats75827643mo__ats
mobcaps1543463mobcaps
mochas13310663mocha_s
modals93914453mo_dals
modulars1165833modulars
moilers93615203moilers
moils76125753moil__s
mola66035633mo_la__
molal75120343mo_la_l
molar75223093mo_la_r
molders103315553molders
molds85324833mo_l_ds
moles74747923mo_l_es
molests93311563molests
molies84429513mo_lies
moll66735703moll___
mollie83517103moll_ie
mollify1555503mollify
mollusc11103093mollusc
molluscs12102593molluscs
mollusk13103123mollusk
mollusks14102653mollusks
molly105222493moll__y
moloch1356483moloch_
mols65948573mo_l__s
molters93816973molters
molts76032093mo_l_ts
mommas94110653momma_s
monads94515303mo_nads
monas74732153mo_na_s
months113812933mo_nths
moola75117033moola__
mooleys1236863mooleys
mools76027173mool__s
morales93619403morales
morals85324633mo_rals
moras76438783mo_ra_s
morass84614503mo_rass
morays114613883mo_rays
morgans10310123morgans
morphs13149433mo_rphs
mortals93914003mortals
mortars93411523mortars
morulas959713morula_s
moths106021553mo__ths
motleys1235683motleys
moulage1037903moulage
moulages1138053moulages
moulds94910993moul_ds
moulins9312703moulins
moults84713703moul_ts
mouths115214533mo_uths
moxas145014393mo_xa_s
mulla74317113mulla__
mullahism1642523mullahism
mullens93611313mullens
mullers93217303mullers
mullets93614783mullets
mulleys12299203mulleys
mulls75124153mull__s
mylars114310443m_ylars
mynahs14416443m_ynahs
nullah9388143nullah_
obeahs1135863_obeahs
odahs95610083_o_dahs
olla44821173_olla__
onlays9398713_onlays
ooliths10268323ooliths
oompahs1434263oompahs
opahs105411983_o_pahs
pillars9313493pillars
polars84419353po_lars
polkas1239103polka_s
pollack1567333pollack
pollacks1656373pollacks
pollard103511143pollard
pollards11299523pollards
pollees93215333pollees
pollens93713303pollens
pollers93420023pollers
polls74627723poll__s
poplars113910333poplars
rollers73117473rollers
rolls55326233roll__s
rollways1444233rollways
selahs9313213_selahs
solans64122493so_lans
soldans83210403soldans
tolans64319273to_lans
tolars64817943to_lars
tolas54532773to_la_s
tollage82610163tollage
tollages92410193tollages
tollbars1045443tollbars
tollers73217463tollers
tolls54728433toll__s
tollways1444133tollways
torahs95115643to_rahs
villas96117263villa_s
volleys13316643volleys
volvas12447993volva_s
wallah124011993wallah_
wallas95719393walla_s
zillah1836563zillah_

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.406440125.6
2DLD Change Limit1340272406.14021828.5
3Display Results2402400.0932580.6
 (SQL Overall)1786912406.63926915.3
 
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.