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

65 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
affiants144523(None) 
affiant1348431affiant_
affiance1645652affiance
affiances1745152affiances
affines1339482affi_nes
affirmants1852762affirmants
affronts1444162affronts
adamants1186343adamants
affaires1444303affaires
affairs1334163aff_airs
affects1535393aff_ects
afferents1546013afferents
affianced1843033affianced
affiches1945233affiches
affidavits2051153affidavits
affinal1336443affi_nal
affine12310503affi_n_e
affined1436413affi_ned
affinity1744993affinity
affirmant1753813affirmant_
affirms1534383affi_rms
affixers2143293affixers
affixes2035503affi_xes
affixments2543073affixments
afflatus1442683afflatus
afflicts1644003afflicts
affluents15133313affluents
affrays1644063affra_ys
affrights1942893affrights
affront1357963affront_
afghanis1542863afghanis
afghans1443573afghan_s
afrits9311903afri__ts
alants67722023a__lants
ambients1246053ambients
amiantus1044383a_miantus
ancients1098973ancients
anoints7311063anoi_nts
aroints7313133aroi_nts
aspirants1145233aspirants
attaints846493attaints
audients946353audients
avians93711563a_vian_s
defiant11311923defiant_
deviants1236733deviants
faints94818783_fai_nts
feints94813873_fei_nts
fiats85324483__fia_ts
flints95617453_fli_nts
giants74713503__giants
haffits1636193haffi__ts
infants102210773inf_ants
maffias15327283maffia__s
mediants11299493mediants
offcasts1643013offcasts
officiants1853423officiants
offings14285833offi_ngs
radiants9259453radiants
raffias13237713raffia__s
raffinate1545023raffinate
raffinates1644363raffinates
ruffians1443793ruffian_s
taffias13377413taffia__s
valiants1137793valiants
variants1139203variants

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 Filter1786911461620.423422437.4
2DLD Change Limit146162657.18620339.8
3Display Results65650.0164062.5
 (SQL Overall)178691657.62523434.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.