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

192 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
totterer821779(None) 
potterer102310261potterer
titterer8268521titterer
tottered9208701tottered
totterers9186811totterers
batterer102713212batterer
bitterer10309772bitterer
cottered112511732cottered
dotterel945062dotterel
fetterer11207812fetterer
fosterer11239522fosterer
letterer8259222letterer
litterer82810172litterer
loiterer837082loiterer
mutterer10218912mutterer
patterer103112172patterer
pottered112311662pottered
potterers11218662potterers
putterer10209912putterer
rottener8216972rottener
stutterer9164912stutterer
tattered92011442tattered
tittered9239492tittered
titterers9236992titterers
torturer835492torturer
totter65021462tott__er
totters74618732totter_s
tottery10388482totter_y
twitterer1243302twitterer
utterer71910462_utterer
alterer72713993_alterer
austerer838383austerer
banterer102811773banterer
barterer102711633barterer
battener10369393battener
battered113315053battered
batterers113110713batterers
bettered113011833bettered
bittered112711833bittered
bolsterer1145483bolsterer
borderer1168103borderer
bothered142110393bothered
bottler94211883bott_ler
bottomer1245103bottomer
buttered112712623buttered
butterier1177453butterier
caterer92815943_caterer
chatterer14196843chatterer
clatterer11186983clatterer
coherer122912783co_herer
cottager11306813cottager
cotter84926673cott__er
cotters94323443cotter_s
cottier93814173cott_ier
coverer123113523co_verer
ditherer12187763ditherer
dodderer1144203dodderer
dotter74419343dott__er
dotterels1043903dotterels
dotters83715973dotter_s
dottier83910923dott_ier
dottrel834463dott_rel
enterer72015633_enterer
falterer11239853falterer
fattener11268113fattener
fettered12259493fettered
fetterers12267043fetterers
filterer11258143filterer
flatterer12187673flatterer
flutterer12185263flutterer
fostered122210453fostered
fosterers12238023fosterers
fritterer12234403fritterer
gatherer12147903gatherer
gettered10258613gettered
guttered10259163guttered
hosteler1137273hosteler
hotter94720083hott__er
hoverer13319823ho_verer
jittered16267223jittered
jitterier1644433jitterier
jotter134315633jott__er
jotters143413803jotter_s
latherer111310443latherer
lettered92910783lettered
letterers9228113letterers
littered92511383littered
litterers9228193litterers
lobsterer1144033lobsterer
loitered938183loitered
loiterers936263loiterers
lotter64025603lott__er
lotteries9311073lotteries
lotters73921063lotter_s
lottery10389833lotter_y
mattered112412903mattered
miterer92511333_miterer
mothered142310103mothered
motleyer1343263motleyer
mottler94410343mott_ler
muttered112610793muttered
mutterers11247373mutterers
nattered92011623nattered
offerer1335543_offerer
oftener1035923_oftener
orderer8127943_orderer
otter54423973_ott__er
otters64021513_otter_s
oysterer1136103oysterer
palterer102411273palterer
pattered112714203pattered
patterers112410123patterers
pesterer102412703pesterer
pewterer13256313pewterer
ponderer112410193ponderer
portered112311533portered
posturer1038923posturer
pothered142311043pothered
potteen9319673potte_en
potter83926983pott__er
potteries11313593potteries
potters94024343potter_s
pottery123011073potter_y
pottier93516493pott_ier
poulterer1145423poulterer
powderer14245593powderer
puttered112611143puttered
putterers11238363putterers
rattener8238533rattener
roisterer946433roisterer
rotter64325463rott__er
rotters74421393rotter_s
scatterer11186293scatterer
shatterer12177203shatterer
smatterer11185813smatterer
smotherer1444633smotherer
soberer93110353so_berer
softener1145613softener
solderer947183solderer
sorcerer1036433sorcerer
sputterer11165263sputterer
steerer73113633_steerer
stuttered10145763stuttered
stutterers10164303stutterers
tamperer12248893tamperer
taperer92511793t_aperer
tatter64024573tatt__er
tatters74520483tatter_s
tattier74216243tatt_ier
tattler73112213tatt_ler
tattooer844373tattooer
teetered9258303teetered
temperer12227723temperer
tenderer9228733tenderer
tentered96412103tentered
tethered1238493tethered
tetter64322453tett__er
tetters74320473tetter_s
tinkerer1286803tinkerer
titter63421163titt__er
titters74219623titter_s
tochered1437913tochered
together1243743together
tooter64420803toot__er
tooters73818773tooter_s
toothier1136423toothier
tootler73511123toot_ler
torture738593torture_
tortured935843tortured
torturers944343torturers
tortures838913tortures
toter55932133to_t__er
toters65026363to_ter_s
tother94117143to_t_her
totted74319953tott__ed
tottering10229613tottering
tourer64115073to__urer
touter63821033tout__er
touters74018353touter_s
towered112911403to_wered
towerier1137123to_werier
trotter73312253trott__er
trotters83310243trotter_s
twittered1333813twittered
twitterers1342673twitterers
uttered82712433_uttered
utterers8218653_utterers
waterer103314073_waterer
winterer112110443winterer
witherer14187953witherer
wonderer12249183wonderer
yattered12239533yattered

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.1701051123.5
2DLD Change Limit1461621927.76618820.8
3Display Results1921920.0762526.3
 (SQL Overall)1786911928.01222302.9
 
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.