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

205 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
titterer826852(None) 
bitterer10309771bitterer
litterer82810171litterer
tittered9239491tittered
titterers9236991titterers
totterer8217791totterer
twitterer1243301twitterer
batterer102713212batterer
bittered112711832bittered
ditherer12187762ditherer
fetterer11207812fetterer
filterer11258142filterer
fritterer12234402fritterer
jittered16267222jittered
jitterier1644432jitterier
letterer8259222letterer
littered92511382littered
litterers9228192litterers
miterer92511332mi_terer
mutterer10218912mutterer
patterer103112172patterer
potterer102310262potterer
putterer10209912putterer
stutterer9164912stutterer
tattered92011442tattered
tinkerer1286802tinkerer
titter63421162titt__er
titters74219612titter_s
tottered9208702tottered
totterers9186812totterers
twittered1333812twittered
twitterers1342672twitterers
utterer71910462_utterer
winterer112110442winterer
witherer14187952witherer
alterer72713993_alterer
austerer838383austerer
banterer102811773banterer
barterer102711633barterer
battener10369393battener
battered113315053battered
batterers113110713batterers
bettered113011833bettered
bickerer16106773bickerer
bistered112913323bistered
bitter84622673bitt__er
bitterest1147713bitterest
bitterly1335603bitterly
bittern94810683bitter_n
bitterns10428943bitterns
bitters94920353bitter_s
bittier94211663bitt_ier
buttered112712623buttered
butterier1177453butterier
caterer92815933_caterer
chatterer14196843chatterer
chittered15166413chittered
cipherer1545573cipherer
cittern9339133citter_n
citterns10318113citterns
clatterer11186983clatterer
cottered112511733cottered
dithered13189293dithered
ditherers13196683ditherers
dotterel945063dotterel
enterer72015633_enterer
falterer11239853falterer
fattener11268113fattener
fettered12259493fettered
fetterers12267043fetterers
filtered12259043filtered
filterers12206973filterers
fingerer12127223fingerer
fitter94120033fitt__er
fitters104517743fitter_s
flatterer12187673flatterer
flittered13196253flittered
flutterer12185263flutterer
fosterer11239523fosterer
frittered13205163frittered
fritterers13203393fritterers
gatherer12147903gatherer
gettered10258613gettered
gittern8337503gitter_n
gitterns9326563gitterns
glittered11195403glittered
guttered10259153guttered
hinderer1238273hinderer
hitter94419863hitt__er
hitters104717583hitter_s
integer837993_integer
jitter133314993jitt__er
jitters144314463jitter_s
jittery17346443jitter_y
kipperer16294723kipperer
kittened1334523kittened
kittler11338163kitt_ler
latherer111310443latherer
lettered92910783lettered
letterers9228113letterers
limberer12187053limberer
lingerer9118303lingerer
listener8158313listener
litter64324853litt__er
litters73422563litter_s
littery103710493litter_y
littler7348553litt_ler
loiterer837083loiterer
mattered112412903mattered
mitered103213233mi_tered
miterers10219683mi_terers
mittened1136363mittened
muttered112610793muttered
mutterers11247373mutterers
nattered92011623nattered
nittier73512243nitt_ier
oysterer1136103oysterer
palterer102411273palterer
pattered112714203pattered
patterers112410123patterers
pesterer102412703pesterer
pewterer13256313pewterer
pilferer1344923pilferer
pottered112311663pottered
potterers11218653potterers
puttered112611143puttered
putterers11238363putterers
rattener8238533rattener
ritter63822413ritt__er
ritters74020613ritter_s
roisterer946433roisterer
rottener8216973rottener
scatterer11186293scatterer
shatterer12177203shatterer
silverer11216733silverer
simperer1237173simperer
sincerer1037203sincerer
sintered92213903sintered
sistered92612803sistered
sitter63323383sitt__er
sitters74221543sitter_s
skittered1434633skittered
skitterier1442423skitterier
smatterer11185813smatterer
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
tiered73613973ti__ered
tightener1344703tightener
tillered937433tillered
tilter63417693tilt__er
tilters73315933tilter_s
tiltmeter1144343tiltmeter
timbered13137383timbered
tinkered1387683tinkered
tinkerers1395423tinkerers
tinter63923643tint__er
tinters74221103tinter_s
tireder837703ti_reder
titer55430613ti_t__er
titers64526403ti_ter_s
titfer9409523ti_t_fer
titfers10318933titfer_s
tither94920283ti_t_her
tithers104216733tither_s
titre54619393ti_t_re_
titres64718933ti_t_res
tittering102310303tittering
tittie63213153titt_ie_
titties73617363titt_ies
tittle63613323titt_le_
tittles73413253titt_les
tittuped1142063tittuped
torturer835493torturer
totter65021463tott__er
totters74618733totter_s
tottery10388483totter_y
twitter10278093twitt__er
twitters11296773twitter_s
twittery14303893twitter_y
uttered82712433_uttered
utterers8218653_utterers
waterer103314073_waterer
wintered122111573wintered
winterers12209723winterers
winterier1238333winterier
withered15169433withered
witherers15146843witherers
wittier103910823witt_ier
yattered12239533yattered

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 Filter1786911461620.1731032896.0
2DLD Change Limit1461622057.29620033.2
3Display Results2052050.0932204.3
 (SQL Overall)1786912057.56223630.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.