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

165 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
terrify133635(None) 
torrify1335011torrify
aerify122810112ae_rify
certify1546242certify
horrify1635022horrify
merrily1238632merrily
metrify1535622metrify
petrify1536572petrify
tearily10311152tearily
terribly1344922terribly
terrier73414962terrier
terries73425632terries
terrific1344802terrific
terrine72517572terrine
territ63421382terri_t
territs72714502territs
terry84721872terr__y
testify13246942testify
torrefy1353352torrefy
verbify1834992verbify
verify153110162ve_rify
versify1636332versify
aerily93017013ae_rily
beatify1536593beatify
berried103714053berried
berries94423553berries
berry104521773berr__y
carnify1555883carnify
clarify1536093clarify
cornify1536253cornify
deify124112763de__ify
densify1435293densify
derrick1435803derrick
derries83124623derries
derris73615273derri_s
derry94721373derr__y
edify12308563_e_dify
eerily92913563_eerily
erring73816483_erring
esterify1445623este_rify
eternity1146683eternity
etherify1744443etherify
ferity122813343fe_rity
ferrety13287013ferrety
ferric1139993ferri_c
ferried113411533ferried
ferries103521083ferries
ferrite103312753ferrite
ferry116020803ferr__y
fortify1636523fortify
furrily1337613furrily
gentrify1544683gentrify
glorify1444583glorify
herried113514473herried
herries104025083herries
herring113615883herring
herry114922473herr__y
jellify2054543jellify
jerkily2134623jerkily
jerrid14259143jerri_d
jerrids15277743jerrids
jerries143817513jerries
jerry155016183jerr__y
kerria10339923kerri_a
kerrias11289513kerrias
kerries113317913kerries
kerry124916093kerr__y
leerily1037633leerily
merrier92612303merrier
merry104721493merr__y
micrify1744693micrify
mortify1536223mortify
nervily1336863nervily
nigrify1444133nigrify
nitrify1335793nitrify
overrife14169933overrife
perfidy1635273perfidy
perkily1637813perkily
perries93226603perries
perry105222713perr__y
purify14399153_purify
rarify123210063_rarify
rectify1536453rectify
reedify1465763reedify
reify114814973__reify
repurify1643803repurify
reunify1344453reunify
reverify1744813reverify
scarify1537443scarify
scorify1535203scorify
serif84132133se_rif_
serifs94017053se_rifs
serried82513973serried
serries73925353serries
serry84824123serr__y
sorrily1039833sorrily
stellify1443883stellify
tackify1934493tackify
tardily11269583tardily
tariff12711363t_ariff
tarried83914133tarried
tarrier74323173tarrier
tarries73324263tarries
tarring83318303tarring
tarry85422513tarr__y
tartily103511573tartily
tearier73815613tearier
tearing84021493tearing
teary85124053tear__y
techily1537123techily
temerity1346903temerity
tensity1039103tensity
tenuity1037453tenuity
tepefy1434803te_pefy
terai53525483terai__
terais64023513terai_s
terbia8311163terbi_a
terbias9310743terbias
terbic10410963terbi_c
terbium1147293terbium
tergite8311003tergite
terming104016003terming
termini93410813termini
termite9313893termite
termly1138433te_rmly
ternary1038343ternary
ternion739493ternion
terra54419673terr__a
terrace93311843terrace
terrae62915213terr_ae
terrain7410853terrain
terrains8410323terrains
terrane72814233terrane
terras63516973terr_as
terreen7257573terreen
terrene72411033terrene
terret63425623terr_et
terrets72913583terrets
terrible1046643terrible
terriers84210823terriers
terrified13147583terrified
terrifier12126603terrifier
terrifies12139723terrifies
terrifying1745163terrifying
terrines82117553terrines
territory1245103territory
terror63811733terr_or
terrors73112213terrors
tersely1038113tersely
tertial7313863tertial
tertian7511193tertian
tertiary1145433tertiary
testily102910803testily
tetri52716453tetri__
tetris62816293tetri_s
thrift12412043t_hrift
thrifty1634193t_hrifty
torrid7311853torri_d
torridly1284473torridly
turfy114315403t_ur_fy
typify1734523t_ypify
verily122616053ve_rily
verity123714853ve_rity
vitrify1645003vitrify
wearily1338783wearily

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 Filter1786911340270.410435831.7
2DLD Change Limit1340271657.62317581.9
3Display Results1651650.0632619.0
 (SQL Overall)1786911658.09622071.5
 
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.