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 “mulls” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

204 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
mulls7512415(None) 
bulls75629571bulls
culls75425811culls
dulls64523741dulls
fulls84623521fulls
gulls65222981gulls
hulls84923561hulls
lulls54119651lulls
malls76233431malls
mells75031331mells
mills75435051mills
molls75129781molls
mules75034291mules
mull65128801mull_
mulla74317111mulla
mullas84215931mullas
nulls55019981nulls
pulls74425051pulls
alls46740922_alls
balls76236412balls
bells76432162bells
bills75632862bills
bolls75531312bolls
buhls105111802buhls
bulbs96016932bulbs
bulks115920612bulks
bull65634872bull_
bulla74620562bulla
bully105124812bully
burls74228852burls
calls75634732calls
cells75428062cells
cull65929642cull_
cullis84115992cullis
cully105520462cully
culms95314192culms
cults75022552cults
curls74927102curls
dells66630942dells
dills65530972dills
dolls66126922dolls
duals65620082duals
duels65619232duels
dull56430442dull_
dully94921632dully
ells46431352_ells
falls85727652falls
fells85327382fells
fills84632372fills
fuels87117352fuels
full75229152full_
fully114820862fully
furls85322052furls
galls64729322galls
gills64728192gills
gules64831042gules
gulfs94915302gulfs
gull54828452gull_
gully94020682gully
gulps84715072gulps
guls55930852gu_ls
halls85633782halls
hells85032042hells
hills85431352hills
hulas84920882hulas
hulks125715482hulks
hull75428782hull_
hullo84417452hullo
hullos94916292hullos
hurls86522712hurls
ills47030422_ills
jells125522162jells
jills125122822jills
kills94526172kills
lalls55324132lalls
lolls512121732lolls
lull44225762lull_
lulus54315162lulus
maills84215282maills
mails76037782mails
males75049792males
mall64639372mall_
malms95021552malms
malts76331752malts
marls75535162marls
mauls76524952mauls
meals75933372meals
melds84822382melds
mell64935612mell_
mels65941532m_els
melts74930102melts
merls77423902merls
mewls105813232mewls
milds86422052milds
miles74645072miles
milks115020582milks
mill66541482mill_
mille75029132mille
milles84526562milles
milos75428012milos
mils66045332m_ils
milts75430712milts
moils76125752moils
molas75132092molas
molds85324832molds
moles74747922moles
moll66735702moll_
molly105222492molly
mols65948572m_ols
molts76032092molts
mools76027172mools
moulds94910992moulds
moults84713702moults
mucks134622642mucks
mucus94015742mucus
muds75530652mu_ds
muffs134114212muffs
muggs94912322muggs
mugs76232042mu_gs
muhly1358522muhly
mulch124012972mulch
mulct93820082mulct
mulcts10298712mulcts
mule65236972mu_le
muled85824432muled
muley104819282muley
muleys11409642muleys
mulish11311902mulish
mullah113710732mullah
mullahs12388732mullahs
mulled94721552mulled
mullen83714762mullen
mullens93611312mullens
muller83820352muller
mullers93217302mullers
mullet84126822mullet
mullets93614782mullets
mulley114013452mulley
mulleys12299202mulleys
mumms85513152mumms
mumps115619102mumps
mums85732772mu_ms
mumus95517282mumus
munis75022002munis
muns65535922mu_ns
muons75816172muons
murals84016762murals
muras75329582muras
mures75937222mures
murks114821732murks
murrs75521302murrs
mus55946752mu__s
muses75134302muses
musks116119642musks
muss64933762mu_ss
musts75527442musts
mutes75033782mutes
muts64839982mu_ts
mutts75120252mutts
nills54926672nills
null45125312null_
nurls55519682nurls
palls74332562palls
pills74130972pills
polls74627722polls
pules74538812pules
pulis74225602pulis
pull64731662pull_
pulps95116482pulps
puls65437562pu_ls
purls74723352purls
quells15359702quells
quills153811852quills
quolls15327302quolls
rills55032712rills
rolls55326232rolls
rules55234252rules
sculls84613882sculls
sells55134432sells
sills55135992sills
skulls10429642skulls
smalls84514122smalls
smells83914742smells
stulls63912982stulls
sulks94818462sulks
sully84622902sully
sulus54821882sulus
talls55133432talls
tells55828942tells
tills54631712tills
tolls54728432tolls
trulls64110282trulls
tules54532792tules
tulle54019932tulle
tulles63218892tulles
ulus45622562_ulus
vills86429322vills
walls85529382walls
wells85426192wells
wills84528962wills
yells85821942yells
yills83921552yills
yules84521582yules
zills144020782zills

Search took 2 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 Filter178691538000.296603685.8
2DLD Change Limit538002041.53035163.4
3Display Results2042040.0464434.8
 (SQL Overall)1786912041.87295454.6
 
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.