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

117 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
horrify163502(None) 
torrify1335011torrify
cornify1536252cornify
fortify1636522fortify
hoarily1338972hoarily
hornily1338282hornily
horribly16114312horribly
horrid10311562horri_d
horridly15114792horridly
horrific1643622horrific
horsily1338842horsily
mortify1536222mortify
sorrily1039832sorrily
terrify1336352terrify
torrefy1353352torrefy
aerify122810113_aerify
carnify1555883carnify
certify1546243certify
clarify1536093clarify
coalify1536683coalify
codify1537163co_dify
copurify1843053copurify
cornily12410853cornily
corrida1078513corrida
corrie83621233corri_e
corries94026803corries
corrody13136143corrody
forrit91916623forri_t
furrily1337613furrily
glorify1444583glorify
gorily10612503go_rily
hardily143310273hardily
harried113815533harried
harrier104417753harrier
harries103525493harries
harry115322953harr__y
herried113514453herried
herries104025073herries
herring113615883herring
herry114922473herr__y
hoarier104211743hoarier
hoary114516763hoar__y
hokily16409093ho_kily
holily123612953ho_lily
homily144712333ho_mily
hominy144511483ho_miny
hooray123011373hoor_ay
horary12310383ho_rary
hording123517053hording
hornier103012463hornier
horning113015003horning
hornist102314823hornist
hornito1047073hornito
horny115619623ho_r_ny
horrent10313553horrent
horrible13135233horrible
horrider1236533horrider
horrified16145063horrified
horrifies15146393horrifies
horrifying2043983horrifying
horror988723horr_or
horrors1078693horrors
horsefly1744883horsefly
horsey125115403ho_rsey
horsier103013243horsier
horsing113215583horsing
horsy116318393ho_r_sy
houri85915253houri__
houris94514583houri_s
hourly12369623hour_ly
hurray12459913hurr_ay
hurried113511043hurried
hurrier103412943hurrier
hurries103919653hurries
hurry114917183hurr__y
jollify2044263jollify
lorries74518353lorries
lorry86315673lorr__y
merrily1238633merrily
metrify1535623metrify
micrify1744693micrify
modify1537173mo_dify
mollify1555503mollify
morrion959003morrion
morris83814733morri_s
nigrify1444133nigrify
nitrify1335793nitrify
notify1236943no_tify
orrery936783_orrery
orrice81410163_orrice
orris54516553_orri_s
ossify1244973_ossify
petrify1536573petrify
porridgy1542133porridgy
purify14399153_purify
rarify123210063_rarify
reify114814973__reify
scarify1537443scarify
scorify1535203scorify
sorority1146903sorority
sorrier72313733sorrier
sorry84618253sorr__y
thornily1444163thornily
torrid7311853torri_d
torridly1284473torridly
verbify1834993verbify
verify153110163_verify
versify1636333versify
vitrify1645003vitrify
wordily1437853wordily
worried11308693worried
worrier102311683worrier
worries104117133worries
worrit92313313worri_t
worrits10258683worrits
worry116114333worr__y
zombify2642253zombify

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271176.59320328.7
3Display Results1171170.0303900.0
 (SQL Overall)1786911177.02925422.0
 
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.