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

98 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
modellers124539(None) 
modelers1138461mode_lers
modeller1136611modeller_
yodellers1343971yodellers
modeler1039292mode_ler_
modelled1236432modelle_d
morelles10710492morelle_s
yodelers1235672yode_lers
yodeller1244852yodeller_
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
marcellers1443833marcellers
meddlers12318203med_dlers
melders103213913m__elders
melters93918313m__elters
mewlers12288983m__ewlers
micelles1288833micelle_s
middlers123410193mid_dlers
millers93621343m__illers
misdealers1344613misdealers
modeled1139463mode_le_d
modelings1335563modelings
modelists1246473modelists
modelling1336883modelling
models94216353mode_l__s
moderner1145523moderner_
modernes1138423moderne_s
modester1197483modester_
modifiers1584483modifiers
modulars1165833mod_ulars
modules102511003mod_ule_s
moilers93615203mo__ilers
molders103315553mo__lders
molesters1198873molesters
molters93816973mo__lters
monellins1147423monellins
moneyers1337423mone_yers
moneyless1444653moneyless
morelle91210803morelle__
morellos10136953morell_os
mottlers10388183mo_ttlers
moulders11348343mo_ulders
moulters103510783mo_ulters
moveless1367753move_less
muddlers12428813mud_dlers
mullers93217303m__ullers
pedallers1244763pedallers
pollers93420023po__llers
propellers1455203propellers
quellers17237533_quellers
ravellers12257163ravellers
remodelers1342793remode_lers
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
yellers103912953__yellers
yodeler1136343yode_ler_
yodelled1334603yodelle_d
yodlers11298923yod__lers

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 Limit148641987.14320809.3
3Display Results98980.0462130.4
 (SQL Overall)178691987.60923484.2
 
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.