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

100 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
clarifies144863(None) 
clarified1546971clarified
clarifier1446121clarifier
clarifiers1544011clarifiers
clarities11312481clarities
calcifies1638922calcifies
carnifies1439892c_arnifies
charities14312742charities
claries93422202clar__ies
classifies1555002classifies
clerisies1147252clerisies
coalifies1439112coalifies
glorifies1346362glorifies
rarifies11311932_rarifies
scarifies1439602scarifies
aerifies111313393_aerifies
alacrities1246673alacrities
alkalifies1743233alkalifies
basifies13310493_basifies
beatifies1459283beatifies
calamities1448473calamities
calcified1746893calcified
calvities1438943calvities
canities101519263c_anities
caprifigs1742703caprifigs
carafes125015703c_araf_es
caribes113715643c_ari_bes
carices114220953c_ari_ces
caries85147623c_ar__ies
carioles10817073c_arioles
carnies94123963c_ar_nies
carnified1547293c_arnified
carries94328013c_ar_ries
casefies1339213c_asefies
cavities131412613c_avities
celerities1289773celerities
certifies14310323certifies
charlies133414233char_lies
citifies13310683c_itifies
clarences1346453clarences
clarify1536093clarif__y
clarifying1944853clarifying
clarinet10317293clari_net
clarinets1137683clarinets
clarioned1245723clarioned
clarionet1149833clarionet
clarionets1243903clarionets
clarions10310493clari_ons
clarkias1444793clar_kias
claroes93113733clar__oes
classified1644283classified
classifier1543853classifier
classifiers1642783classifiers
clavicles1643673clavicles
clergies1137903cler_gies
coalified1546813coalified
codifies1439643c_odifies
copurifies1754363copurifies
cornifies1439003cornifies
crucifies1646123crucifies
falsifies1545983falsifies
gasifies1238693_gasifies
glorified1445003glorified
glorifier1344233glorifier
glorifiers1442593glorifiers
gratifies1347993gratifies
hilarities1347153hilarities
horrifies15146393horrifies
laities7320343_la_ities
laxities1539093_laxities
metrifies1439803metrifies
micrifies16118673micrifies
molarities12129433molarities
nazifies2036063_nazifies
nigrifies1346363nigrifies
nitrifies12107923nitrifies
opacifies1645463opacifies
pacifies15311223_pacifies
parities10522973_parities
petrifies14310363petrifies
polarities121211773polarities
purifies13311923_purifies
qualifies2147503qualifies
ramifies13310503_ramifies
rarefies1138993_rarefies
rarified1239053_rarified
rarities8316333_rarities
ratifies11313513_ratifies
salifies11314793_salifies
salsifies1247253salsifies
scarified1547293scarified
scarifier1446653scarifier
scarifiers1544103scarifiers
scorifies1448023scorifies
terrifies12139723terrifies
torrifies12137033torrifies
unclarified1752783unclarified
unclarities1345333unclarities
verifies141313483_verifies
vitrifies1547223vitrifies

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411006.42023152.8
3Display Results1001000.0462173.9
 (SQL Overall)1786911006.88925938.6
 
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.