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

220 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
mullahs1238873(None) 
mollahs12328281mollahs
mullah113710731mullah_
mullas84215931mulla_s
nullahs10316991nullahs
cullays12347702cullays
fellahs13428392fellahs
fullams1236552fullams
hallahs133912462hallahs
mollah11319452mollah_
moolahs12347382moolahs
mulla74317112mulla__
mullahism1642522mullahism
mullens93611312mullens
mullers93217302mullers
mullets93614782mullets
mulleys12299202mulleys
mulls75124152mull__s
nullah9388142nullah_
wallahs13409472wallahs
zillahs1935382zillahs
allays94313743_allays
almahs118611613_almahs
ballads104212913ballads
blahs105616513__blahs
bulla74620563bulla__
bullace113410673bullace
bullaces12299433bullaces
bullae83416163bulla_e
bullate93415073bullate
bullbats1255893bullbats
bullets93516393bullets
bullies94121893bullies
bullish12511193bullish
bullous9311663bullous
bulls75629573bull__s
burlaps1156253burlaps
callans94518473callans
callas84526753calla_s
cellars93713693cellars
chalahs15289883chalahs
challahs16377563challahs
collars93816573collars
cullay113910173culla_y
cullers93418843cullers
cullets94015613cullets
cullies94419963cullies
cullis84115993cull_is
culls75425813cull__s
cutlas8313093cutla_s
cutlass938013cutlass
dollars83311023dollars
dulias71212743dulia_s
dullard936603dullard
dullards1045493dullards
dullish1148743dullish
dulls64523743dull__s
fallals103310193fallals
fellah124910773fellah_
fellas95116963fella_s
fulhams1543983fulhams
fullam1138363fulla_m
fullers103817373fullers
fulls84623523full__s
fulmars1246423fulmars
galahs105512673_galahs
gulags837543gu_lags
gullets84013713gullets
gulleys11438523gulleys
gullies84717313gullies
gulls65222983gull__s
halalahs14367443halalahs
hallah124115403hallah_
halvahs16417533halvahs
hollas94616903holla_s
hulas84920883hu_la_s
hullers103616263hullers
hulloas103911913hulloas
hulloes104113923hulloes
hulloos104010073hulloos
hullos94916293hull_os
hulls84923563hull__s
huppahs1743333huppahs
hurrahs13336773hurrahs
huzzahs2143083huzzahs
jubbahs2143623jubbahs
jubhahs2242353jubhahs
keblahs1634563keblahs
kiblahs1634153kiblahs
kulaks976113ku_laks
lallans74113533lallans
lullaby1243363lullaby
lullers73213353lullers
lulls54119653lull__s
malars85020683m_alars
mallard10310273mallard
mallards1138323mallards
mallees93315973mallees
mallets93318493mallets
malleus92911313malleus
mallows123714323mallows
malls76233433mall__s
malthas1237913malthas
matsahs1236563matsahs
matzahs2134483matzahs
medlars10259443medlars
medullas1144513medulla_s
megillahs1542233megillahs
mellows123812233mellows
mells75031333mell__s
mikvahs19162493mikvahs
millage103112743millage
millages113212893millages
milldams1344633milldams
millers93621333millers
milles84526563mill_es
millets94216843millets
mills75435053mill__s
milpas101710273milpa_s
mislays12349243mislays
molars85517323m_olars
molas75132093m_ola_s
mollies93420233mollies
molls75129783moll__s
molochs1435223molochs
moolah11409193moolah_
moolas83615593moola_s
muclucs1343683muclucs
mudcaps1444103mudcaps
mudcats1236223mudcats
mudflaps1641803mudflaps
mudflats1442983mudflats
mudlark1463913mudlark
mudlarks1542883mudlarks
mudras94212253mudra_s
muggars11316643muggars
mughals1355753mughals
muhlies1238933muhlies
mukluks1242413mukluks
mulch124012973mu_lch_
mulches143210673mulches
mulcts10298713mu_lcts
mules75034293mu_l_es
muletas937383muletas
muleys11409643mu_leys
mulish11311903mulish_
mull65128803mull___
mullahisms1752103mullahisms
mulled94721553mull_ed
mullein9278563mullein
mulleins10277053mulleins
mullen83714763mull_en
muller83820353mull_er
mullet84126823mull_et
mulley114013453mull_ey
mulligans1244773mulligans
mulling103819993mulling
mullion91911173mullion
mullions101910343mullions
mullite9313013mullite
mullites10411643mullites
mullock1535713mullock
mullocks1645033mullocks
murals84016753mu_rals
muras75329563mu_ra_s
murras84916003murra_s
murrhas12286163murrhas
muscats1138933muscats
muslins9312213muslins
musths11589483mu_sths
mutuals937123mutuals
mylars114310443m_ylars
mynahs14416443m_ynahs
nulls55019983null__s
ollas54218283_olla_s
outlaws10249603outlaws
outlays102610903outlays
pillars9313483pillars
pujahs18404943pu_jahs
pullers93618483pullers
pullets94015163pullets
pulleys12399143pulleys
pullmans1253933pullmans
pulls74425053pull__s
pullups1134233pullups
pulsars9358913pulsars
punkahs16284783punkahs
purdahs13285483purdahs
quillais1745003quillais
rupiahs1253333rupiahs
selahs9313213_selahs
subahs114512383su_bahs
succahs1435323succahs
sukkahs1382703sukkahs
suldans8299723suldans
sulfas9311563sulfa_s
sullage859913sullage
sullages939973sullages
sullies74122223sullies
sulphas1236243sulphas
sultans72411833sultans
sunnahs10326593sunnahs
surahs94515543su_rahs
tulles63218893tull_es
tussahs10335113tussahs
uhlans937573_uhlans
ulans54921303_u_lans
ullage739043_ullage
ullages838953_ullages
ulnas55716533_ulna_s
ulvas84511503_ulva_s
unlash938793_unlash
unlays93810493_unlays
villas96117263villa_s
vulgars11306533vulgars
vulvas12388843vulva_s
wallah124011993wallah_
wallas95719393walla_s
yulans958673yu_lans
zillah1836563zillah_

Search took 8 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.1561145455.1
2DLD Change Limit1340272206.75019855.9
3Display Results2202200.0762894.7
 (SQL Overall)1786912206.98225593.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.