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

62 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
afflict154704(None) 
afflicts1644001afflicts
affect1448902aff_ect
afflicted1843432afflicted
afflicter1742822afflicter
inflict1248622inflict
abulic106411423abulic_
addict10711203a_ddict
affair1234353affai_r
affaire1344463affaire
affairs1334163affairs
affects1535393aff_ects
affiant1348433affiant
affiche1844313aff_iche
affiliate1545323affiliate
affine12310503aff_ine
affirm1435523aff_irm
affix1836003aff_i_x
afflicters1852243afflicters
afflicting1943483afflicting
affliction1843543affliction
afflictive21102803afflictive
affluent1494553affluent
afflux1942793affl_ux
affricate1744973affricate
affright1844193affright
affront1357963affront
afloat9315153a_float
afrit8323173a_fri_t
airlift1048583airlift
alist56136783a__list
alit46155693a__li_t
amylic13108713amylic_
anglice1089213anglice
apomict1349053apomict
astrict9614793astrict
atelic8313703atelic_
aulic74420243a_ulic_
baffling1756053baffling
conflict1547753conflict
deflect13399973deflect
delict94320333_delict
effect1437443eff_ect
flic96223733__flic_
flick145017213__flick
flics105418363__flics
flint87333503__flint
flirt87424753__flirt
flit76539273__fli_t
folic105319323_folic_
haffit1538533haff_i_t
inflect1249223inflect
inflicts1345613inflicts
maffick2143523maff_ick
office1435693off_ice
offline1345783offline
raffling1567063raffling
reflect123913713reflect
relict83623903_relict
wafflier1733953wafflier
waffliest1844233waffliest
waffling1845423waffling

Search took 7 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 Filter1786911340270.423422437.4
2DLD Change Limit134027626.07622058.4
3Display Results62620.0331878.8
 (SQL Overall)178691626.53227356.2
 
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.