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

125 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
titterers923699(None) 
litterers9228191litterers
titterer8268521titterer_
totterers9186811totterers
twitterers1342671twitterers
batterers113110712batterers
bitterer10309772bitterer_
ditherers13196682ditherers
fetterers12267042fetterers
filterers12206972filterers
fritterers13203392fritterers
letterers9228112letterers
litterer82810172litterer_
miterers10219682mi_terers
mutterers11247372mutterers
patterers112410122patterers
potterers11218662potterers
putterers11238362putterers
stutterers10164302stutterers
tinkerers1395422tinkerers
tittered9239492tittere_d
titters74219622titt__ers
totterer8217792totterer_
twitterer1243302twitterer_
utterers8218652_utterers
winterers12209722winterers
witherers15146842witherers
alterers82512493_alterers
banterers112410003banterers
barterers11269633barterers
batteners11238163batteners
batterer102713213batterer_
bickerers17115593bickerers
bittered112711833bittere_d
bitterest1147713bitterest
bitterness1245553bitterness
bitterns10428953bitter_ns
bitters94920363bitt__ers
caterers102814403_caterers
chatterers15205463chatterers
cipherers1644893cipherers
citterns10318123citter_ns
clatterers12155423clatterers
ditherer12187763ditherer_
dotterels1043903dotterels
enterers82214153_enterers
falterers12238033falterers
fatteners12236873fatteners
fetterer11207813fetterer_
filterer11258143filterer_
fingerers13136303fingerers
fitters104517753fitt__ers
flatterers13175913flatterers
flutterers13184593flutterers
fosterers12238023fosterers
fritterer12234403fritterer_
gatherers13156883gatherers
gitterns9326573gitter_ns
hinderers1337353hinderers
hitters104717593hitt__ers
integers937783_integers
jittered16267223jittere_d
jitterier1644433jitterier_
jitters144314473jitt__ers
kipperers17233823kipperers
latherers12158853latherers
letterer8259223letterer_
lingerers10126923lingerers
listeners9147323listeners
littered92511383littere_d
litters73422573litt__ers
loiterers936263loiterers
miterer92511333mi_terer_
mutterer10218913mutterer_
oysterers1245573oysterers
palterers11249533palterers
patterer103112173patterer_
pesterers112510453pesterers
pewterers14216043pewterers
pilferers1444583pilferers
potterer102310263potterer_
putterer10209913putterer_
ratteners9237263ratteners
ritters74020623ritt__ers
roisterers1045113roisterers
scatterers12205043scatterers
shatterers13185723shatterers
silverers12215753silverers
simperers1335933simperers
sitters74221553sitt__ers
smatterers12174873smatterers
sputterers12174583sputterers
steerers82511353_steerers
stutterer9164913stutterer_
tamperers13227313tamperers
taperers10269773t_aperers
tattered92011443tattere_d
tatters74520483tatt__ers
tattlers8369693tatt_lers
tattooers943633tattooers
temperers13247023temperers
tenderers10227803tenderers
tetters74320473tett__ers
tighteners1444043tighteners
tilters73315953tilt__ers
tiltmeters1244123tiltmeters
tinkerer1286803tinkerer_
tinters74221113tint__ers
titers64526413ti_t__ers
titfers10318933ti_t_fers
tithers104216733ti_t_hers
titres64718933ti_t_re_s
titter63421163titt__er_
tittering102310313tittering
titties73617363titt_ie_s
tittles73413253titt_le_s
torturers944343torturers
tottered9208703tottere_d
totters74618733tott__ers
twittered1333813twittere_d
twitters11296773twitt__ers
utterer71910463_utterer_
waterers112312783_waterers
winterer112110443winterer_
witherer14187953witherer_

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411257.93618730.0
3Display Results1251250.1101136.4
 (SQL Overall)1786911258.46921099.4
 
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.