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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

100 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
yodeller124485(None) 
modeller1136611modeller
yodeler1136341yode_ler
yodelled1334601yodelled
yodellers1343971yodellers
modeler1039292mode_ler
modelled1236432modelled
modellers1245392modellers
yeller94214512y__eller
yodeled1236862yode_led
yodelers1235672yode_lers
yodler10389942yod__ler
beveller13387663beveller
bowelled1446173bowelled
cadelle1039923cadelle_
cadelles1139973cadelles
coddler113710833cod_dler
comelier12310653comelier
compeller1546293compeller
cordelle1148433cordelle_
cordelled1346403cordelled
cordelles1248233cordelles
crueller1056453crueller
cupeller1256103cupeller
dealer74122143__dealer
delver104913493__delver
dowelled1356343dowelled
dueller8329833_dueller
duller74017703__duller
dweller11297273_dweller
expeller17105783expeller
feller94419553__feller
fueller10279963_fueller
godlier938893god_lier
gospeller1263743gospeller
groveller1354233groveller
grueller935333grueller
heller93322513__heller
holler93520613ho__ller
homelier1338983homelier
hosteller1245833hosteller
hotelier1137633hotelier
hovelled15146843hovelled
impeller1236083impeller
indweller1393013indweller
jeweller1844123jeweller
labeller10248073labeller
leveller11317593leveller
libeller10297433libeller
loller63315283lo__ller
lonelier838003lonelier
lovelier1136433lovelier
modeled1139463mode_led
modelers1138463mode_lers
moderner1145523moderner
modester1197483modester
morelle91210803morelle_
morelles10710493morelles
novelle1058233novelle_
ocellar936533_ocellar
pedaller1136093pedaller
poller83921853po__ller
propeller1346623propeller
queller16289293_queller
raveller11339263raveller
repeller103010393repeller
reseller83412223reseller
reveller112912183reveller
roller63919793ro__ller
rondelle946813rondelle_
rondelles1046623rondelles
roselle7310243roselle_
roselles8310713roselles
rowelled1236633rowelled
seller63824593__seller
sheller103515883_sheller
shoveller15174543shoveller
smeller94212783_smeller
sneller73512843_sneller
speller95415143_speller
sweller103012463_sweller
teller63519813__teller
toddler9379043tod_dler
toller63819443to__ller
towelled1236353towelled
troweller1244563troweller
wofuller1442403wofuller
yelled104116253y__elled
yellers103912953y__ellers
yelper11458783y__elper
yielder11175113y_ielder
yodel94714083yode_l__
yodeling1357673yodeling
yodelling1435193yodelling
yodels104610073yode_l_s
yodle94515043yod__le_
yodled11389653yod__led
yodlers11298923yod__lers
yodles103714333yod__les
yowler123310043yo__wler

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621006.97020970.2
3Display Results1001000.0462173.9
 (SQL Overall)1786911007.43624030.5
 
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.