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

98 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
scarified154729(None) 
scarifier1446651scarifier
scarifies1439601scarifies
scorified1546191scorified
carnified1547292_carnified
clarified1546972clarified
rarified1239052_rarified
sacrificed18133372sacrificed
salified12310362s_alified
scarfed134711182scar_f_ed
scarifiers1544102scarifiers
scorifier1445412scorifier
scorifies1448022scorifies
acaricide1444413acaricide
acetified1545893acetified
acidified16104983acidified
aerified121310133_aerified
basified1437823_basified
beatified1577863beatified
calcified1746893_calcified
caried94528693_car__ied
carnifies1439893_carnifies
carried103717153_car_ried
casefied1445943_casefied
cavitied14126813_cavitied
certified1548413_certified
citified1438253_citified
clarifier1446123clarifier
clarifies1448633clarifies
coalified1546813coalified
codified1537403_codified
cornified1546623_cornified
esterified1445403esterified
gasified1336533_gasified
glorified1445003glorified
gratified1446253gratified
horrified16145063horrified
metrified1547853metrified
micrified17126793micrified
nazified2144993_nazified
nigrified1445323nigrified
nitrified1346723nitrified
opacified1744393opacified
pacified1638363_pacified
petrified1548333petrified
purified1438743_purified
qualified2245843qualified
ramified1438043_ramified
rarefied1245913_rarefied
rarifies11311933_rarifies
ratified12310503_ratified
saccharified23112093saccharified
sacrifice16134533sacrifice
sacrificer17133063sacrificer
sacrifices17134413sacrifices
salifies11314793s_alifies
satisfied1343873s_atisfied
scarcities1446403scarcities
scared95227293scar___ed
scarfer124511083scar_f_er
scarfing14309713scar_fing
scarier94017873scar__ier
scarify1537443scarif__y
scarifying1945013scarifying
scariose1037593scariose_
scarped124314393scar__ped
scarpered1435103scarpered
scarphed1635433scar_phed
scarred104512633scar__red
scarrier10298453scar_rier
scarted104816123scar__ted
scorifiers1543603scorifiers
scraiched1744203scraiched
scraighed1643593scraighed
scribed124510643sc_ri_bed
scried95817303sc_r__ied
scrieved14366203sc_rieved
scrimped1555313sc_rimped
scripted13117553sc_ripted
scrived134511113sc_ri_ved
scurfier13267053scur_fier
scurried11267053scur_ried
sealifted1344573sealifted
serifed11811463s_erif_ed
seriffed1594973s_eriffed
sharifian1542783sharifian
signified1446043signified
sissified1345543sissified
snarfed11378753snar_f_ed
specified1746243specified
stratified1445173stratified
tackified1944713tackified
tariffed1533723_tariffed
terrified13147573terrified
torrified13125593torrified
unclarified1752783unclarified
verified151510393_verified
vitrified1645983vitrified

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 Filter1786911486410.1701051123.5
2DLD Change Limit148641987.81319024.8
3Display Results98980.0462130.4
 (SQL Overall)178691988.02922255.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.