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

59 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
abrasive134575(None) 
abrasives1444061abrasives
ablative1348242ablative
abrasion1046622abrasion
abrasively1853622abrasively
abusive1245282ab_usive
abase76023483ab_as__e
abasia8712953ab_asi_a
abasias9711013ab_asias
abasing10610673ab_asing
abaxile1644083ab_axile
ablatives1445503ablatives
abortive1346883abortive
abrade9313053abra__de
abrading1239503abrading
abrasions1145803abrasions
abrosia939273abrosi_a
abrosias1049033abrosias
acrasia9310033acrasi_a
acrasias1048893acrasias
acrasin9311223acrasi_n
acrasins1039973acrasins
adhesive1543803adhesive
allusive1144783allusive
amative12311733a_mative
amusive1246253a_musive
appraisive1753203appraisive
arabize1849343a_rabize
archive154610483a_rchive
arcsine94512393a_rcsine
arrestive1246753arrestive
arrive91311793a_r_rive
arsine64021043a_r_sine
assuasive1242623assuasive
atrazine1748403atrazine
aversive1447443aversive
braise84318753_bra_ise
braize174113113_bra_ize
brasier94516753_brasier
brasil8713863_brasi_l
brasils9410973_brasils
brassie93411523_brassie
brave104925503_bra__ve
corrasive1445063corrasive
curative13310403curative
cursive1237833cur_sive
derisive1247503derisive
durative1239073durative
embracive1843853embracive
erosive1039193_erosive
evasive1344663_evasive
invasive1444833invasive
narrative1247373narrative
nonabrasive1652573nonabrasive
obtrusive1443423obtrusive
parasite10314843parasite
pervasive1744483pervasive
suasive1037853_suasive
vibrative1745583vibrative

Search took 9 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.1701051123.5
2DLD Change Limit146162598.67316852.5
3Display Results59590.0301966.7
 (SQL Overall)178691598.87320138.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.