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

72 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
yodellers134397(None) 
modellers1245391modellers
yodelers1235671yode_lers
yodeller1244851yodeller_
modelers1138462mode_lers
modeller1136612modeller_
yellers103912952y__ellers
yodeler1136342yode_ler_
yodelled1334602yodelle_d
yodlers11298922yod__lers
bevellers14276143bevellers
bowelless1443833bowelless
cadelles1139973cadelle_s
coddlers12359173cod_dlers
codeless112010113code_less
compellers1645193compellers
cordelles1248233cordelle_s
cupellers1374863cupellers
dealers84118613__dealers
delvers113411993__delvers
duellers9268223_duellers
dwellers12356083_dwellers
expellers18104753expellers
fellers104117543__fellers
fuellers11277983_fuellers
gospellers1363023gospellers
grovellers1443323grovellers
gruellers1034183gruellers
hellers103619833__hellers
hollers103818233ho__llers
hostellers1344683hostellers
hoteliers1245803hoteliers
impellers1345103impellers
indwellers1472353indwellers
jewellers1943543jewellers
labellers11206553labellers
levellers12286053levellers
libellers11236033libellers
lollers72713793lo__llers
modeler1039293mode_ler_
modelled1236433modelle_d
morelles10710493morelle_s
pedallers1244763pedallers
pollers93420023po__llers
propellers1455203propellers
quellers17237533_quellers
ravellers12257163ravellers
repellers11278883repellers
resellers9299933resellers
revellers12319513revellers
rollers73117473ro__llers
rondelles1046623rondelle_s
roselles8310713roselle_s
sellers73721323__sellers
shellers112812583_shellers
shovellers16173783shovellers
smellers10329773_smellers
spellers102812763_spellers
tellers73717603__tellers
toddlers10346963tod_dlers
tollers73217463to__llers
trowellers1343663trowellers
yeller94214513y__eller_
yelpers12348203y__elpers
yielders12164743y_ielders
yodeled1236863yode_le_d
yodelling1435193yodelling
yodels104610073yode_l__s
yodler10389943yod__ler_
yodles103714333yod__le_s
yokeless1535303yoke_less
yowlers13328923yo__wlers

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 Filter1786911486410.420425454.8
2DLD Change Limit148641727.00021234.4
3Display Results72720.0332181.8
 (SQL Overall)178691727.45323975.7
 
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.