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
asserters956382asserters
misenters1139522misenters
abaters95115193ab__aters
abetter958323ab_etter_
abettors1056133ab_ettors
aborters1038563ab_orters
absconders1542373absconders
absence1137693absence__
absent84016993absent___
absenteeism1561113absenteeism
absenting1236993absenting
absently1345813absent_ly
absinthes1442673absinthes
absinths1342953absint_hs
absolvers1443123absolvers
absorbers1353973absorbers
abutters1056983ab_utters
accentors13116043accentors
accepters15114603accepters
affecters1763933affecters
alieners889823alien_ers
amenders11288343a_menders
ammeters1237693amme_ters
anointers936993anointers
anteaters939333anteaters
arresters948193arresters
arsenates979363arsenate_s
arsenites9149163arsenite_s
ascenders1235683ascenders
assented957513assente_d
assentor865293assentor_
assents74512223assent__s
asserter877563asserter_
assertors965963assertors
assisters936353assisters
assorters965723assorters
asters65631603a_s__ters
attenders1045273attenders
attesters935803attesters
augmenters1343513augmenters
avengers1235583a_vengers
averters11249503a_verters
banters94623113_b_anters
baseness10910943basen_ess
basters94930303bas__ters
beaters94925033_b_eaters
belters93819413_b_elters
benders104021063_b_enders
besetters11136633besetters
betters94422093_b_etters
bleaters103412313_bleaters
blenders115210993_blenders
bunters94717113_b_unters
carpenters1445833carpenters
cementers1338303cementers
centers94420593__centers
consenters12410843consenters
dabsters1137053dabs__ters
decenters122410373decenters
deserters10129983deserters
disinters1039703disinters
dissenters1197723dissenters
dysentery1643043dysentery
enters64425643___enters
fomenters1437853fomenters
incenters112510293incenters
indenters102710023indenters
inserters92210283inserters
insetters9187133insetters
inventers12269523inventers
lamenters1137683lamenters
masseters1136283masse_ters
mesentera1144653mesentera
mesentery1444843mesentery
misenter10310833misenter_
misinters1138163misinters
observers1443963observers
orienters937613orienters
passengers1343213passengers
presenters1239863presenters
reenters82915303_reenters
renters74224813__renters
repenters112511553repenters
resetters9129463resetters
seaters74028933__seaters
senders83022353__senders
setters73822063__setters
sinters74024073__sinters
subcenters1446153subcenters
tenters73921103__tenters
upsetters1143653upsetters
venters103717723__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.186960704.3
2DLD Change Limit1486411037.61019532.3
3Display Results1031030.0462239.1
 (SQL Overall)1786911037.84222786.4
 
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.