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 “abstracters” with Change Limit: [1] [2] [3] [4]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

105 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
abstracters154410(None) 
abstracter1444691abstracter_
abstractors1554411abstractors
abstracted1544842abstracte_d
abstractest1553622abstractest
abstractness1683012abstractness
abstractor1444382abstractor_
abstracts1346592abstract__s
attracters1245112a_ttracters
abstainers1243453abst_ainers
abstract1249223abstract___
abstractedly2061773abstractedly
abstracting1645183abstracting
abstraction1545883abstraction
abstractions1645783abstractions
abstractive1854893abstractive
abstractly17123393abstract_ly
abstricted1544093abstricte_d
abstricts1355183abstrict__s
attracter1146093a_ttracter_
attractors1245843a_ttractors
castraters1246473castra_ters
obstructors1564003obstructors
subtracters1573803subtracters
abaters95115204ab___a_ters
abetters1057174abet___ters
aborters1038574ab_or__ters
abraders1137344ab__ra_ders
absenters1156174abs__enters
absorbers1353984absor__bers
abstainer1144404abst_ainer_
abstractable1852194abstractable
abstractedness1962574abstractedness
abstractnesses1862294abstractnesses
abstrict1257944abstrict___
abstricting1654504abstricting
abstruser1162974abstr_user_
abutters1056994abut___ters
anteaters939344a_ntea_ters
arbitragers14142664arbitra_gers
arbitrates12117014arbitra_te_s
arbitrators1354214arbitra_tors
asserters956394asser__ters
assorters965734assor__ters
astrachans1553624a_strachans
astricted1247444a_stricte_d
astricts1049464a_strict__s
astrocytes1565974a_strocyte_s
attachers14134884a__ttachers
attackers15144014a__ttackers
attracted1246074a_ttracte_d
attractor1145824a_ttractor_
attracts1047794a_ttract__s
australes9317764austra_le_s
azotobacters2561004azotobacters
barrackers1843764_barrackers
barraters1138044_barra_ters
betatters1134964_bet_atters
betrayers1445014_betra_yers
bracers114616704_b__rac_ers
castrater1148524castra_ter_
castrates11312674castra_te_s
castrators1247444castra_tors
characters1745504_characters
contractors1549164contractors
detractors13147294_detractors
disgracers1444734disgrac_ers
distracted1448874distracte_d
distracts1249284distract__s
distrainers1255054distrainers
estrangers11376104_estrangers
extractors1946424_extractors
instructors1355384instructors
lustrates939464lustra_te_s
mistraces13312294mistrac_e_s
obstacles1343714obst_acle_s
obstructed1544234obstructe_d
obstructor1453754obstructor_
obstructs1344574obstruct__s
postmasters15115324postmasters
protractors1546624protractors
racetrackers2051854racetrackers
restrainers1145124restrainers
retracers11149554_retrac_ers
retractors12158584_retractors
stackers143413564__st_ackers
stactes91914634__st_acte_s
starters83714774__st_arters
staters73922344__st_a_ters
strafers11379914__stra_fers
strainers9510384__strainers
straitens946234__straitens
straiter8311784__straiter_
stranders10389934__stranders
strangers104112164__strangers
strappers1346744__strappers
strayers113510144__stra_yers
stricter1039424__stricter_
strutters955694__strutters
substrates12168554substra_te_s
subtracter1454624subtracter_
tracers94917844___trac_ers
trackers143512854___trackers
tractors10312564___tractors
upstaters11174804upst_a_ters

Search took 10 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 Filter1786911488190.423422437.4
2DLD Change Limit1488191058.93616653.9
3Display Results1051050.0631666.7
 (SQL Overall)1786911059.42218965.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.