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

103 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
absenters115617(None) 
absentees1164531absentees
absenter1086771absenter_
assenters966991assenters
abetters1057172ab_etters
absences1247672absence_s
absented1156612absente_d
absentee1067662absente_e
absents93510722absent__s
assenter867702assenter_
assentors955652assentors
asserters956392asserters
misenters1139532misenters
abaters95115203ab__aters
abetter958323ab_etter_
abettors1056133ab_ettors
aborters1038573ab_orters
absconders1542373absconders
absence1137703absence__
absent84016993absent___
absenteeism1561113absenteeism
absenting1236993absenting
absently1345813absent_ly
absinthes1442673absinthes
absinths1342953absint_hs
absolvers1443133absolvers
absorbers1353983absorbers
abutters1056993ab_utters
accentors13116053accentors
accepters15114603accepters
affecters1763933affecters
alieners889823alien_ers
amenders11288353a_menders
ammeters1237693amme_ters
anointers937003anointers
anteaters939343anteaters
arresters948193arresters
arsenates979373arsenate_s
arsenites9149163arsenite_s
ascenders1235683ascenders
assented957513assente_d
assentor865293assentor_
assents74512223assent__s
asserter877573asserter_
assertors965973assertors
assisters936353assisters
assorters965733assorters
asters65631603a_s__ters
attenders1045273attenders
attesters935803attesters
augmenters1343513augmenters
avengers1235583a_vengers
averters11249513a_verters
banters94623113_b_anters
baseness10910943basen_ess
basters94930303bas__ters
beaters94925043_b_eaters
belters93819413_b_elters
benders104021063_b_enders
besetters11136633besetters
betters94422093_b_etters
bleaters103412323_bleaters
blenders115210993_blenders
bunters94717123_b_unters
carpenters1445833carpenters
cementers1338313cementers
centers94420603__centers
consenters12410843consenters
dabsters1137053dabs__ters
decenters122410373decenters
deserters10129983deserters
disinters1039713disinters
dissenters1197723dissenters
dysentery1643043dysentery
enters64425643___enters
fomenters1437853fomenters
incenters112510303incenters
indenters102710033indenters
inserters92210283inserters
insetters9187133insetters
inventers12269533inventers
lamenters1137683lamenters
masseters1136283masse_ters
mesentera1144653mesentera
mesentery1444843mesentery
misenter10310833misenter_
misinters1138183misinters
observers1443963observers
orienters937613orienters
passengers1343213passengers
presenters1239863presenters
reenters82915303_reenters
renters74224813__renters
repenters112511553repenters
resetters9129463resetters
seaters74028943__seaters
senders83022353__senders
setters73822063__setters
sinters74024083__sinters
subcenters1446163subcenters
tenters73921103__tenters
upsetters1143653upsetters
venters103717733__venters

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 Filter1786911486410.470380193.6
2DLD Change Limit1486411036.87321626.8
3Display Results1031030.0502060.0
 (SQL Overall)1786911037.39324170.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.