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

153 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
tinkerer128680(None) 
tinkered1387681tinkered
tinkerers1395421tinkerers
bickerer16106772bickerer
fingerer12127222fingerer
hankerer15248232hankerer
hinderer1238272hinderer
lingerer9118302lingerer
sincerer1037202sincerer
tenderer9228732tenderer
tinker103619922tink__er
tinkers113517142tinker_s
tinkler113610542tink_ler
tinklier1255442tinklier
titterer8268522titterer
trinketer1344562trinketer
winterer112110442winterer
banterer102811773banterer
bickered17108003bickered
bickerers17115593bickerers
bitterer10309773bitterer
blinkered1644413blinkered
bunkered15177183bunkered
cankered153010223cankered
cindered1239793cindered
cipherer1545573cipherer
clinkered1634773clinkered
dickered16117533dickered
dinkier123411503dink_ier
ditherer12187763ditherer
enterer72015633_enterer
filterer11258143filterer
fingered13128333fingered
fingerers13136303fingerers
gingered11127743gingered
hankered16289443hankered
hankerers16226713hankerers
hindered1339453hindered
hinderers1337353hinderers
hinkier143610793hink_ier
hunkered16186923hunkered
indexer15287253_indexer
inferrer11217443_inferrer
inhere9313713_inhere_
inhered11313163_inhered
inheres10315173_inheres
injurer14318473_injurer
inker94421093_ink__er
inkers104018833_inker_s
inkier104013783_ink_ier
inserter82312133_inserter
insurer73312803_insurer
integer837993_integer
inverter112411073_inverter
jinker174013543jink__er
jinkers183511813jinker_s
junketer1943713junketer
kinkier10319433kink_ier
kipperer16294723kipperer
limberer12187053limberer
lingered10129643lingered
lingerers10126923lingerers
linker104321473link__er
linkers114317713linker_s
litterer82810173litterer
miterer92511333mi_terer
nickered15117023nickered
panderer112210913panderer
pickeer153710113picke_er
pickerel1645273pickerel
picketer16187433picketer
pilferer1344923pilferer
pinkened1535753pinkened
pinker125322443pink__er
pinkers134118603pinker_s
pinkeye16326493pinkeye_
pinkeyes17335973pinkeyes
ponderer112410193ponderer
puckerer1645793puckerer
renderer9239743renderer
sickener1436603sickener
silverer11216733silverer
simperer1237173simperer
sincere9310553sincere_
sinker103620903sink__er
sinkers113618543sinker_s
sintered92213903sintered
sneerer73512313_sneerer
snickerer15134563snickerer
stinker113313313stink__er
stinkeroo1342343stinkeroo
stinkers123111133stinker_s
stinkier12278543stink_ier
sunderer9310523sunderer
tamperer12248893tamperer
tanker104521123tank__er
tankers113416913tanker_s
taperer92511793t_aperer
temperer12227723temperer
tendered102510603tendered
tenderers10227803tenderers
tentered96412103tentered
thickener1844163thickener
thinker143610683think__er
thinkers15308703thinker_s
thunderer1344253thunderer
ticker124321503tick__er
tickers133617723ticker_s
ticketed15146643ticketed
tickler133612653tick_ler
tiered73613973ti__ered
tillered937443tillered
timbered13137383timbered
tinder73821803tin__der
tinders84219173tinder_s
tindery11389363tinder_y
tingler83613343tin_gler
tinglier956403tinglier
tinier63622233tin__ier
tinkering1437703tinkering
tinkertoy1641993tinkertoy
tinkle103714453tink_le_
tinkled123910473tink_led
tinklers12298183tinkler_s
tinkles113713923tink_les
tinner64119963tin__ner
tinners73717313tinner_s
tinnier72910143tin_nier
tinseled935763tinseled
tinter63923643tin__ter
tinters74221113tinter_s
tinware1038603tinware_
tinwares1137913tinwares
tireder837703ti_reder
tittered9239493tittered
titterers9236993titterers
totterer8217793totterer
trinketed1444253trinketed
trinketers1443733trinketers
tuckered1535963tuckered
tunneler864473tunneler
twinkler1564073twink_ler
twitterer1243303twitterer
veneerer1145033veneerer
wanderer122210123wanderer
wickeder1843983wickeder
winker134220293wink__er
winkers143517113winker_s
wintered122111573wintered
winterers12209723winterers
winterier1238333winterier
witherer14187953witherer
wonderer12249183wonderer

Search took 7 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.420425454.8
2DLD Change Limit1461621536.37622923.8
3Display Results1531530.0632428.6
 (SQL Overall)1786911536.85926052.0
 
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.