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

126 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
absenter108677(None) 
absented1156611absented
absentee1067661absentee
absenters1156171absenters
assenter867701assenter
abetter958322ab_etter
absence1137692absence_
absences1247672absences
absent84016992absent__
absentees1164532absentees
absently1345812absently
absents93510722absent_s
assented957512assented
assenters966992assenters
assentor865292assentor
asserter877562asserter
misenter10310832misenter
abater85518123ab__ater
abetted1058323ab_etted
abetters1057173ab_etters
abettor956193ab_ettor
aborter939923ab_orter
abrupter1243793abrupter
absconder1443013absconder
abseiled1144733abseiled
absenting1236993absenting
absinth1244973absint_h
absinthe1342643absinthe
absinthes1442673absinthes
absinths1342953absinths
absoluter1142923absoluter
absolver1343683absolver
absorber1254303absorber
absurder11134353absurder
abutter957513ab_utter
accented13107773accented
accentor12106123accentor
accepter14144933accepter
adepter1036113a_depter
affecter1644523affecter
agented939423a_gented
alerter72111513a_lerter
aliener71011193alien_er
amender10349613a_mender
ammeter1148393amme_ter
ancienter1145393ancienter
anointer837823anointer
anteater8311603anteater
arrester839253arrester
arsenate81010483arsenate_
arsenates979363arsenates
arsenite8119663arsenite_
arsenites9149163arsenites
ascender1136733ascender
assent65119953assent__
assentors955653assentors
assents74512223assent_s
asserted957903asserted
asserters956383asserters
assertor865713assertor
assister836753assister
assorter866663assorter
aster55434893a_s__ter
asunder856223a_sunder
attender935913attender
attester836503attester
augmenter1254123augmenter
avenger1135493a_venger
averter102410553a_verter
banter84825333_b_anter
baster85333593bas__ter
beater84729393_b_eater
belter84720963_b_elter
bender95223303_b_ender
besetter10137973besetter
better84723703_b_etter
bleater94515303_bleater
blender104613843_blender
blunter94512033_blunter
bunter85020383_b_unter
carpenter1346493carpenter
cementer1239193cementer
center84421413__center
consenter11312493consenter
dabster1036703dabs__ter
decenter112412163decenter
deserter91211603deserter
disinter9310673disinter
dissenter1059133dissenter
dysentery1643043dysentery
enter54726383___enter
fomenter1339263fomenter
incenter102212093incenter
indenter92311443indenter
inserter82312133inserter
insetter8218593insetter
inventer112410843inventer
lamenter1038863lamenter
lisente71210703lisente_
masseter1037063masse_ter
mesentera1144653mesentera
mesentery1444843mesentery
misenters1139523misenters
misinter1038833misinter
obscener1244323obscen_er
observer1344723observer
orienter838313orienter
passenger1243413passenger
patienter1145553patienter
presenter11311633presenter
recenter102715443recenter
reenter73217793_reenter
renter64527413__renter
repenter102813863repenter
resented92716963resented
resetter81511833resetter
seater64534153__seater
sender73824413__sender
sente56432873__sente_
setter64023723__setter
silenter838873silenter
sinter63625923__sinter
subcenter1347063subcenter
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.1701051123.5
2DLD Change Limit1461621267.98618302.3
3Display Results1261260.0632000.0
 (SQL Overall)1786911268.21921741.2
 
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.