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

303 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
mullah11371073(None) 
mollah11319451mollah
mulla74317111mulla_
mullahs12388731mullahs
mullas84215931mullas
nullah9388141nullah
bulla74620562bulla_
bullae83416162bullae
cullay113910172cullay
fellah124910772fellah
fullam1138362fullam
hallah124115402hallah
mollahs12328282mollahs
moolah11409192moolah
mulch124012972mu_lch
mulish11311902mulish
mull65128802mull__
mulled94721552mulled
mullen83714762mullen
muller83820352muller
mullet84126822mullet
mulley114013452mulley
mulls75124152mull_s
nullahs10316992nullahs
wallah124011992wallah
zillah1836562zillah
allay85620393_allay
almah106917253_almah
alula5317093alula_
alulae6312743alulae
alular6311363alular
ampulla1164303ampulla_
ampullae1253773ampullae
ampullar1253133ampullar
ballad94315323ballad
blah98625063__blah
bulbar1039583bulbar
bull65634873bull__
bullace113410673bullace
bullate93415073bullate
bullbat1158553bullbat
bulled94626493bulled
bullet84528613bullet
bullish12511193bullish
bulls75629573bull_s
bully105124813bull_y
burlap1098353burlap
calla74827073calla_
callan83619603callan
callas84526753callas
cella75420313cella_
cellae84915933cellae
cellar84514983cellar
chalah143511663chalah
challah15458323challah
collar83816173collar
culch124512833cu_lch
cull65929643cull__
cullays12347703cullays
culled94022473culled
culler84322253culler
cullet84727313cullet
cullis84115993cullis
culls75425813cull_s
cully105520463cull_y
culpa93610963culpa_
culpae10389263culpae
cultch13385953cultch
cutlas8313103cutlas
dollar74110983dollar
dulia61014983dulia_
dulias71212743dulias
dull56430443dull__
dullard936603dullard
dulled84719423dulled
duller74017703duller
dullish1148743dullish
dulls64523743dull_s
dully94921633dull_y
fallal93612693fallal
fella84918653fella_
fellahs13428393fellahs
fellas95116963fellas
fulham1435303fulham
full75229153full__
fullams1236553fullams
fulled103820653fulled
fuller94220383fuller
fulls84623523full_s
fully114820863full_y
fulmar1137253fulmar
galah95917643_galah
gulag7310823gu_lag
gular6314833gu_lar
gulch113810603gu_lch
gull54828453gull__
gulled84521373gulled
gullet74924833gullet
gulley104213163gulley
gulls65222983gull_s
gully94020683gull_y
halalah13429393halalah
hallahs133912463hallahs
hallal94415563hallal
halvah15499833halvah
holla84918493holla_
hollas94616903hollas
hula74923753hu_la_
hulas84920883hu_las
hull75428783hull__
hulled103920013hulled
huller93919103huller
hullo84417453hull_o
hulloa95011183hulloa
hulloas103911913hulloas
hulloo94511733hulloo
hullos94916293hullos
hulls84923563hull_s
huppah1644183huppah
hurrah12369183hurrah
huzzah2044423huzzah
jubbah2034353jubbah
jubhah2142803jubhah
keblah1545313keblah
kiblah1535583kiblah
kulak858823ku_lak
lallan63414183lallan
lull44225763lull__
lullaby1243363lullaby
lulled74516443lulled
luller63415483luller
lulls54119653lull_s
malar76424443m_alar
mall64639373mall__
mallard10310273mallard
malled94626113malled
mallee84525593mallee
mallei84414633mallei
mallet84433053mallet
mallow114014743mallow
malls76233433mall_s
maltha1137513maltha
matsah1138233matsah
matzah2035963matzah
medlar93010463medlar
medulla1044713medulla_
medullae1143203medullae
medullar1143463medullar
medullas1144513medullas
megillah1443233megillah
mell64935613mell__
melled95023023melled
mellow114112223mellow
mells75031333mell_s
mikvah18143473mikvah
milch124413373m_ilch
milia72719573milia_
mill66541493mill__
millage103112753millage
milldam1245473milldam
mille75029133mill_e
milled94326173milled
miller84625413miller
milles84526563milles
millet84030743millet
mills75435053mill_s
milpa92111403milpa_
milpas101710273milpas
mislay113510683mislay
mola66035633m_ola_
molal75120343m_olal
molar75223093m_olar
molas75132093m_olas
moll66735703moll__
mollie83517103mollie
molls75129783moll_s
molly105222493moll_y
moloch1356483moloch
moola75117033moola_
moolahs12347383moolahs
moolas83615593moolas
much115224033mu__ch
mucluc1245053mucluc
mudcap1335133mudcap
mudcat11311203mudcat
mudflap1542183mudflap
mudflat1364883mudflat
mudlark1463913mudlark
mudra83912433mudra_
mudras94212263mudras
muggar10316443muggar
mughal1236273mughal
muhly1358523muhl_y
mukluk1143503mukluk
mulct93820083mu_lct
mulcts10298713mulcts
mule65236973mu_l_e
muled85824433mu_led
mules75034293mu_les
muleta839233muleta
muletas937383muletas
muley104819283mu_ley
muleys11409643muleys
muling93519883muling
mullahism1642523mullahism
mullein9278563mullein
mullens93611313mullens
mullers93217303mullers
mullets93614783mullets
mulleys12299203mulleys
mulligan1145163mulligan
mulling103819993mulling
mullion91911173mullion
mullite9313013mullite
mullock1535713mullock
munch124917103mu_nch
mura65633303mu_ra_
mural75225113mu_ral
murals84016763murals
muras75329583mu_ras
murra74519083murra_
murras84916013murras
murrha11366453murrha
musca9311763musca_
muscae10410673muscae
muscat10314663muscat
mush94929123mu__sh
muslin8312213muslin
musth105314783mu_sth
mutch125016173mu_tch
mutual838503mutual
mutular936653mutular
mylar105311533m_ylar
mynah13569563m_ynah
null45125313null__
nulled74318273nulled
nulls55019983null_s
olla44821173_olla_
ollas54218283_ollas
outlaw9279643outlaw
outlay92711793outlay
pillar8314023pillar
pujah17478543pu_jah
pula65129373pu_la_
pull64731663pull__
pulled94322193pulled
puller83820813puller
pullet84026333pullet
pulley113713403pulley
pullman1135403pullman
pulls74425053pull_s
pullup1045893pullup
pulpal10408453pulpal
pulsar8329363pulsar
punkah15347093punkah
purdah12288753purdah
quillai1644993quillai
rupiah1146213rupiah
selah8319613_selah
subah106015213su_bah
succah1336643succah
sukkah12123733sukkah
sulcal8311283sulcal
suldan72611043suldan
sulfa8313923sulfa_
sulfas9311563sulfas
sullage859913sullage
sullen62914293sullen
sully84622903sull_y
sulpha1135403sulpha
sultan63012593sultan
sunnah9369353sunnah
surah86823253su_rah
tulle54019933tull_e
tulles63218893tulles
tussah9356233tussah
uhlan849113_uhlan
ulan46527393_u_lan
ullage739043_ullage
ulna46317333_ulna_
ulnad65611453_ulnad
ulnae55214573_ulnae
ulnar56013983_ulnar
ulnas55716533_ulnas
ulpan7310123_ulpan
ulva75412693_ulva_
ulvas84511503_ulvas
unlash938793_unlash
unlay84613703_unlay
villa85321233villa_
villae95615383villae
villas96117263villas
vulgar10426823vulgar
vulva11448803vulva_
vulvae12438033vulvae
vulval12417663vulval
vulvar12427963vulvar
vulvas12388843vulvas
walla85321033walla_
wallahs13409473wallahs
wallas95719393wallas
yulan8411493yu_lan
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 Filter1786911127160.420425454.8
2DLD Change Limit1127163035.78319490.9
3Display Results3033030.0963156.3
 (SQL Overall)1786913036.29928368.2
 
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.