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 “verified” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

155 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
verified15151039(None) 
aerified121310131aerified
verbified18146011verbified
verifier14159201verifier
verifies141313481verifies
versified16147591versified
aerifies111313392aerifies
certified1548412certified
deified123112412de_ified
edified12339712_edified
metrified1547852metrified
petrified1548332petrified
purified1438742purified
rarified1239052rarified
reified112913782re_ified
reverified1745122reverified
serifed11811462serif_ed
seriffed1594972seriffed
terrified13147572terrified
verbifies17157132verbifies
verifiers15166062verifiers
verities111418042verities
versifier15156532versifier
versifies15159332versifies
vilified1547242vilified
vinified1537542vinified
vitrified1645982vitrified
vivified1845892vivified
acetified1545893acetified
aeried74221863aer__ied
basified1437823basified
beatified1577863beatified
berimed124912283beri_med
beringed1298173beringed
berried103714043ber_ried
carnified1547293carnified
certifier1447353certifier
certifies14310323certifies
citified1438253citified
clarified1546973clarified
codified1537403codified
cornified1546623cornified
defied115016383de__fied
deifier113013123de_ifier
deifies113317453de_ifies
densified1446713densified
derided102914253deri_ded
derived123912763deri_ved
diversified1962953diversified
drifted12367953_drifted
edifier11309263_edifier
edifies113012283_edifies
esterified1445403esterified
etherified1744083etherified
ferities111416713ferities
ferried113411523fer_ried
fortified1646503fortified
gasified1336533gasified
gentrified1545673gentrified
glorified1445003glorified
grifted12379583_grifted
herried113514453her_ried
horrified16145063horrified
humified1745653humified
ignified1386213ignified
jellified2044813jellified
kerfed14358233ker_f_ed
merited10313853meri_ted
metrifies1439803metrifies
micrified17126793micrified
minified1439653minified
modified1537273modified
mortified1547383mortified
nazified2144993nazified
nidified1346763nidified
nigrified1445323nigrified
nitrified1346723nitrified
notified1238363notified
ossified1276433ossified
overdried1439013overdried
overfed142510253over_f_ed
overfeed15299443over_feed
overplied1539063overplied
pacified1638363pacified
periled10316323peri_led
perilled11410113perilled
perished14310083perished
petrifier1447123petrifier
petrifies14310363petrifies
purifier1338573purifier
purifies13311923purifies
ramified1438043ramified
rarefied1245913rarefied
rarifies11311933rarifies
ratified12310503ratified
rectified1539243rectified
redefied1368223redefied
reedified1446503reedified
reifier103414523re_ifier
reifies104218283re_ifies
repurified1645163repurified
rerigged1136243rerigged
resifted12310153resifted
reunified1346593reunified
reverifies1645973reverifies
riffed133811563__riffed
rifled104115003__rifled
rifted104115313__rifted
salified12310363salified
scarified1547293scarified
scorified1546193scorified
seriated92717023seriated
serried82513963ser_ried
specified1746253specified
tariffed1533723tariffed
tepefied1444573tepefied
terrifier12126603terrifier
terrifies12139723terrifies
testified1397843testified
torrified13125593torrified
trifid1039063_trifi_d
trifled113711963_trifled
typified1743923typified
uglified1345293uglified
unified112413573_unified
unrifled1237423unrifled
vanitied12138213vanitied
variated121211393variated
varied104817863var__ied
varisized2244493varisized
veiled103714543ve_i_led
veined104413913ve_i_ned
veinier10269583ve_inier
verbicide1784633verbicide
verbid122311313ver_bi_d
verdured13255763verdured
verged114815163ver__ged
veridic1338143veridi_c
verier94620963ver__ier
verify153110163verif__y
verifying1936413verifying
verite94323443veri_te_
verites103822263veri_tes
vermicide1785253vermicide
vernier102711273ver_nier
versed104515513ver__sed
versifiers16154143versifiers
vilifier1456693vilifier
vilifies1439593vilifies
vinifies1439873vinifies
viricide1446423viricide
virilized2246233virilized
vitrifies1547223vitrifies
vivifier1745173vivifier
vivifies1747023vivifies

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.406440125.6
2DLD Change Limit1461621557.29620033.2
3Display Results1551550.0632460.3
 (SQL Overall)1786911557.76523012.4
 
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.