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

131 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
totterers918681(None) 
potterers11218661potterers
titterers9236991titterers
totterer8217791totterer_
batterers113110712batterers
dotterels1043902dotterels
fetterers12267042fetterers
fosterers12238022fosterers
letterers9228112letterers
litterers9228192litterers
loiterers936262loiterers
mutterers11247372mutterers
patterers112410122patterers
potterer102310262potterer_
putterers11238362putterers
stutterers10164302stutterers
titterer8268522titterer_
torturers944342torturers
tottered9208702tottere_d
totters74618732tott__ers
twitterers1342672twitterers
utterers8218652_utterers
alterers82512493_alterers
banterers112410003banterers
barterers11269633barterers
batteners11238163batteners
batterer102713213batterer_
bitterer10309773bitterer_
bolsterers1244683bolsterers
borderers1276333borderers
bottlers103810013bott_lers
bottomers1344353bottomers
caterers102814403_caterers
chatterers15205463chatterers
clatterers12155423clatterers
coherers132310733co_herers
cottagers12305383cottagers
cottered112511733cottere_d
cotterless1244023cotterless
cotters94323443cott__ers
cottiers10399153cott_iers
coverers132712123co_verers
ditherers13196683ditherers
dodderers1243803dodderers
dotterel945063dottere_l
dotters83715973dott__ers
dottrels963493dott_rels
enterers82214153_enterers
falterers12238033falterers
fatteners12236873fatteners
fetterer11207813fetterer_
filterers12206973filterers
flatterers13175913flatterers
flutterers13184593flutterers
fosterer11239523fosterer_
fritterers13203393fritterers
gatherers13156883gatherers
hostelers1246633hostelers
hoverers14289023ho_verers
jotters143413803jott__ers
latherers12158853latherers
letterer8259223letterer_
litterer82810173litterer_
lobsterers1243483lobsterers
loiterer837083loiterer_
lotteries9311073lotteries
lotters73921063lott__ers
miterers10219683_miterers
mottlers10388183mott_lers
mutterer10218913mutterer_
offerers1434933_offerers
orderers9116563_orderers
otters64021513_ott__ers
oysterers1245573oysterers
palterers11249533palterers
patterer103112173patterer_
pesterers112510453pesterers
pewterers14216043pewterers
ponderers12248453ponderers
porteress1137933porteress
posturers1137053posturers
potteens10256793potte_ens
pottered112311663pottere_d
potteries11313593potteries
potters94024343pott__ers
poulterers1244563poulterers
powderers15214793powderers
putterer10209913putterer_
ratteners9237263ratteners
roisterers1045113roisterers
rottener8216973rottener_
rotters74421393rott__ers
scatterers12205043scatterers
shatterers13185723shatterers
smatterers12174873smatterers
smotherers1543813smotherers
softeners1245133softeners
solderers1066533solderers
sorcerers1145323sorcerers
sputterers12174583sputterers
steerers82511353_steerers
stutterer9164913stutterer_
tamperers13227313tamperers
taperers10269773t_aperers
tattered92011443tattere_d
tatters74520483tatt__ers
tattlers8369693tatt_lers
tattooers943633tattooers
temperers13247023temperers
tenderers10227803tenderers
tetters74320473tett__ers
tinkerers1395423tinkerers
tittered9239493tittere_d
titters74219623titt__ers
tooters73818773toot__ers
tootlers8289503toot_lers
torturer835493torturer_
tortures838913torture_s
toters65026363to_t__ers
totter65021463tott__er_
tottering10229613tottering
tottery10388483tott__ery
tourers73512743to__urers
touters74018353tout__ers
trotters83310243trott__ers
twitterer1243303twitterer_
utterer71910463_utterer_
waterers112312783_waterers
winterers12209723winterers
witherers15146843witherers
wonderers13217933wonderers

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.423422437.4
2DLD Change Limit1486411316.53022762.8
3Display Results1311310.0632079.4
 (SQL Overall)1786911317.01625469.1
 
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.