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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

57 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
affecters176393(None) 
affecter1644521affecter_
effecters1764321effecters
affected1744792affecte_d
affectless1842132affectless
affects1535392affect__s
afflicters1852242afflicters
effecter1664772effecter_
effectors1755032effectors
infecters14257582infecters
abetters1057173a_betters
absenters1156173absenters
accepters15114603accepters
affect1448903affect___
affectedly2252153affectedly
affecting1845233affecting
affection1745893affection
affections1845893affections
affective20135413affective
affiches1945233affiche_s
affirmers1742563affirmers
affixers2143293aff_ixers
afflicter1742823afflicter_
affrayers1842213affrayers
afters94717073a_f__ters
ammeters1237693amme_ters
anteaters939333anteaters
arresters948193arresters
assenters966993assenters
asserters956383asserters
attesters935803attesters
averters11249503a_verters
buffeters1783143buffe_ters
defeaters13289093defeaters
defectors15237883defectors
detecters12217753detecters
effacers16244233effac_ers
effected1744993effecte_d
effector1644873effector_
effects1535283effect__s
enfetters1244463enfetters
erecters102611613_erecters
expecters2045473expecters
festers104121393__festers
fetters103517903__fetters
fretters113410303_fretters
infecter13229153infecter_
infectors14218533infectors
infesters12237703infesters
maffickers2441963maffickers
offenders1643403offenders
offerers1434933offe_rers
officers1643803offic_ers
perfecters1745433perfecters
rejecters18257543rejecters
specters122811063_specters
unfetters1244363unfetters

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 Filter1786911486410.1731032896.0
2DLD Change Limit148641579.12316293.0
3Display Results57570.0461239.1
 (SQL Overall)178691579.34219127.7
 
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.