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

159 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
modelled123643(None) 
modeled1139461mode_led
modeller1136611modeller
yodelled1334601yodelled
bowelled1446182bowelled
cordelled1346402cordelled
dowelled1356342dowelled
hovelled15146842hovelled
medalled1246892medalled
melled95023022m__elled
modeler1039292mode_ler
modellers1245392modellers
modemed1336722mode_med
morelle91210802morelle_
morelles10710492morelles
morselled1245962morselled
remodelled1443122remodelled
rowelled1236632rowelled
towelled1236352towelled
yodeled1236862yode_led
yodeller1244852yodeller
belled94626193__belled
bevelled14327823bevelled
bolled94722653bo__lled
boweled132810693bowe_led
cadelle1039923cadelle_
cadelles1139973cadelles
celled94420323__celled
coddled123410573cod_dled
compelled1646133compelled
corbelled1446613corbelled
cordelle1148433cordelle_
cordelles1248233cordelles
cudgelled1443113cudgelled
cupelled1365743cupelled
deled75326543__de_led
delved114112753__delved
dilled84122223__dilled
dolled83518073__dolled
doweled12269773dowe_led
duelled9359753_duelled
dulled84719423__dulled
dwelled12337593_dwelled
embowelled1852103embowelled
excelled18125703excelled
expelled1895883expelled
felled103720303__felled
fuelled11369193_fuelled
gabelled12317583gabelled
gavelled13387363gavelled
gelled84718893__gelled
grovelled1454183grovelled
gruelled1034893gruelled
helled104024703__helled
hostelled1345733hostelled
houselled1346203houselled
hoveled14209293hove_led
impelled1336073impelled
jelled144916063__jelled
jewelled1934343jewelled
knelled12338993_knelled
kvelled15276063_kvelled
labelled11278293labelled
lapelled11227083lapelled
levelled12327453levelled
libelled11317213libelled
lolled74315823lo__lled
malled94626113m__alled
marcelled1445203marcelled
marvelled1544963marvelled
medaled113411613med_aled
meddled123210033med_dled
melded104714713m__elded
melted94219063m__elted
metalled1148993metalled
mewled123710053m__ewled
micelle1178343micelle_
micelles1288833micelles
middled123311903mid_dled
milled94326173m__illed
mobled113213183mo__bled
modally1338403modall_y
model84521693mode_l__
modelers1138463modelers
modeling12311073modeling
modelist11310503modelist
modelling1336883modelling
models94216363mode_l_s
moderated1388143moderated
moderne1037123moderne_
moderner1145523moderner
modernes1138423modernes
modester1197483modester
modified1537273modified
modulated1336713modulated
module93011033mod_ule_
modules102511003mod_ules
moguled1135933mo_guled
moiled94318863mo__iled
molded104414083mo__lded
moldered1237173molde_red
molested11178243molested
molted94217473mo__lted
monellin1047373monellin
moneyed1337493mone_yed
monocled1337113monocled
morello9117793morell_o
morellos10136953morellos
morseled1147193morseled
moseyed1336133mose_yed
mottled10409973mo_ttled
mouille937843mouille_
moulded11348063mo_ulded
moulted103310313mo_ulted
muddled124111593mud_dled
mulled94721553m__ulled
muralled1136423muralled
noddled10358563nod_dled
novelle1058233novelle_
panelled1138973panelled
pedalled1246933pedalled
polled94022003po__lled
pommelled1643083pommelled
propelled1456913propelled
quelled17279273_quelled
ravelled12419783ravelled
rebelled113110333rebelled
refelled122810173refelled
remodeled1344723remode_led
repelled113111593repelled
revelled123712743revelled
rodeoed937883rode_oed
rolled74220243ro__lled
rondelle946813rondelle_
rondelles1046623rondelles
roselle7310243roselle_
roselles8310713roselles
roweled11269863rowe_led
shelled113815093_shelled
shovelled16174413shovelled
smelled103511863_smelled
snelled83313053_snelled
spelled103714743_spelled
swelled113211703_swelled
toddled10328823tod_dled
tolled73819033to__lled
totalled935843totalled
toweled112410223towe_led
trowelled1344443trowelled
umbelled1336273umbelled
undulled1036993undulled
upwelled1434663upwelled
wedeled1237783wede_led
welled103820213__welled
woolled1136643wo_olled
yelled104116253__yelled
yodeler1136343yode_ler
yodellers1343973yodellers
yodled11389653yod__led

Search took 9 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 Filter1786911461620.440406115.9
2DLD Change Limit1461621597.54619369.5
3Display Results1591590.0632523.8
 (SQL Overall)1786911598.04922200.4
 
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.