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

158 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
assenter86770(None) 
absenter1086771absenter
assented957511assented
assenters966991assenters
assentor865291assentor
asserter877571asserter
absented1156612absented
absentee1067662absentee
absenters1156172absenters
ascender1136732ascender
assent65119952assent__
assentors955652assentors
assents74512222assent_s
asserted957902asserted
asserters956392asserters
assertor865722assertor
assister836752assister
assorter866672assorter
dissenter1059132dissenter
masseter1037062masse_ter
misenter10310832misenter
passenger1243412passenger
abetter958323a_better
absence1137713absence_
absences1247673absences
absent84016993absent__
absentees1164533absentees
absently1345813absently
absents93510723absent_s
accented13107773accented
accentor12106133accentor
accepter14144933accepter
adepter1036113a_depter
affecter1644523affecter
agented939423a_gented
alerter72111513a_lerter
aliener71011193alien_er
amender10349613a_mender
ammeter1148393amme_ter
ancienter1145393ancienter
anointer837823anointer
anteater8311603anteater
arrester839253arrester
arsenate81010483arsenate_
arsenates979373arsenates
arsenite8119663arsenite_
arsenites9149163arsenites
ascended1246513ascended
ascenders1235683ascenders
ascent84519653ascent__
ascents93812553ascent_s
asperser10408303asperser
assailer844823assailer
assaulter942753assaulter
assayer1035573ass_ayer
assembler1343613assembler
assenting1038163assenting
assentive1245743assentive
assert64922583assert__
assertors965973assertors
asserts74311793assert_s
assessed945023assessed
assesses737383assesses
assessor843623assessor
asset55932263asse_t__
assets65617663asse_t_s
assigner944853assigner
assisted936233assisted
assisters936353assisters
assistor844823assistor
assorted956603assorted
assorters965733assorters
assuager944343assuager
assumer965363ass_umer
assurer767793ass_urer
aster55434893a_s__ter
asunder856223a_sunder
attender935913attender
attester836503attester
augmenter1254123augmenter
avenger1135493a_venger
averter102410553a_verter
basseted1136743basse_ted
bassetted1244693bassetted
besetter10137973besetter
carpenter1346503carpenter
cassene93111543cassen_e_
cassenes103611293cassen_es
cassette1047813cassette_
cassettes1146703cassettes
cementer1239193cementer
center84421413__center
consenter11312493consenter
decenter112412163decenter
deserter91211603deserter
disinter9310673disinter
dissented1199723dissented
dissenters1197723dissenters
dysentery1643043dysentery
enter54726383___enter
essence947673essence_
essences1047563essences
fastener11227833fasten_er
fomenter1339263fomenter
hastener11259133hasten_er
incenter102212093incenter
indenter92311443indenter
inserter82312133inserter
insetter8218593insetter
inventer112410843inventer
lamenter1038863lamenter
lisente71210703lisente_
masseters1136283masse_ters
mesentera1144653mesentera
mesentery1444843mesentery
messenger1243303messenger
misenters1139533misenters
misinter1038833misinter
orienter838313orienter
passengers1343213passengers
patienter1145553patienter
presenter11311643presenter
recenter102715443recenter
reenter73217793_reenter
renter64527413__renter
repenter102813863repenter
resented92716963resented
resetter81511833resetter
saunter72913453_saunter
scanter94215183_scanter
scented102811883_scented
scepter1138363_scepter
seater64534163__seater
sender73824413__sender
sente56432883__sente_
setter64023723__setter
sheeter103814913_sheeter
shelter103214963_shelter
shunter103611733_shunter
silenter838873silenter
sinter63625923__sinter
skeeter113410413_skeeter
skelter113610003_skelter
slender83413593_slender
smelter93311913_smelter
specter113111733_specter
spelter94113703_spelter
spencer113610973_spencer
spender103713693_spender
stentor739383_stentor
stinter73614513_stinter
svelter10359673_svelter
sweater103712723_sweater
sweeter103212003_sweeter
swelter103711173_swelter
tenter64623933__tenter
upsetter1034643upsetter
venter94218723__venter

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.423422437.4
2DLD Change Limit1461621587.71618942.7
3Display Results1581580.0632507.9
 (SQL Overall)1786911588.20221786.3
 
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.