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

156 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
scorify153520(None) 
scarify1537441scarify
codify1537162_codify
cornify1536252_cornify
glorify1444582glorify
scarily12311702scarily
scoria8513502scori_a
scoriae9310902scoriae
scoring103117212scoring
scurfy14338762scur_fy
acetify1545003acetify
acidify1645243acidify
aerify122810113_aerify
carnify1555883_carnify
certify1546243_certify
citify1437443_citify
clarify1536093clarify
coalify1536683_coalify
coif96337913_co_if_
coifs105718703_co_ifs
comfy153710213_co_mfy
comity13312713_comity
copurify1843053_copurify
corby125018533_cor_by
corf95941483_cor_f_
coria75828323_cori_a
coring94433973_coring
corium10315723_corium
corky145221153_cor_ky
cornily12410853_cornily
corny106023273_cor_ny
corody12149703_corody
cory96941513_cor__y
cosily113613853_cosily
cozily20349703_cozily
esterify1445623esterify
fortify1636523_fortify
gorily10612503_gorily
horrify1635023horrify
metrify1535623metrify
micrify1744693micrify
modify1537173_modify
mortify1536223_mortify
nigrify1444133nigrify
nitrify1335793nitrify
notify1236943_notify
petrify1536573petrify
purify14399153_purify
rarify123210063_rarify
recodify1743943recodify
salify12311373s_alify
salsify1334703salsify
saponify1644183saponify
savorily1445043savorily
scarcity1545093scarcity
scarey115016983scar_ey
scarf105427143scar_f_
scarfs114714683scar_fs
scarier94017873scarier
scaring103421973scaring
scarry116311183scar_ry
scary105222593scar__y
schizy23115043sc_hizy
schrik15206703schri_k
schriks16185743schriks
scoff134413343sco__ff
scoffs14347503sco_ffs
scoping123513823scoping
scorch13198093scor_ch
score75526743scor__e
scored94621133scor_ed
scorer84818263scor_er
scorers94115323scorers
scores84725923scor_es
scorified1546203scorified
scorifier1445413scorifier
scorifies1448023scorifies
scorifying1944473scorifying
scorn75817453scor__n
scorned10229953scorned
scorner9259763scorner
scornful1343333scornful
scorning1169143scorning
scorns85713023scor_ns
scorpion1244803scorpion
scotia8310803scoti_a
scotias939753scotias
scouring112810853scouring
scowing133812093scowing
screwy14659463sc_rewy
scribe104613533sc_ribe
scried95817313sc_ried
scries85226823sc_ries
scrim95419743sc_ri_m
scrimp125110583sc_rimp
scrimpy16486133sc_rimpy
scrims104615933sc_rims
scrip96619193sc_ri_p
scrips105316033sc_rips
script105717903sc_ript
scrive115414943sc_rive
scroggy14243843scroggy
scruff1437963sc_ruff
scruffy1842643scruffy
scry96017763sc_r__y
scurf104719323scur_f_
scurfs113210813scur_fs
scurry11419593scur_ry
scurvily1643783scurvily
scurvy14386103scur_vy
security1346693security
serif84132133s_erif_
serifs94017053s_erifs
sharif122917123sharif_
sharifs13279903sharifs
sherif122915243sherif_
sheriff16287693sheriff
sherifs13299683sherifs
shoring112820073shoring
shortly13387573shortly
shorty124313203shor_ty
showily1636223showily
shrift12413543s_hrift
signify1444853signify
smokily1635373smokily
snoring83917203snoring
snowily1336883snowily
sonority1148533sonority
sootily101810523sootily
sorely94618013s_orely
sori46039843s_ori__
soring74731883s_oring
sorority1146903sorority
sorrily1039833sorrily
sorry84618253s_or_ry
specify1764993specify
spoofy14498553spo_ofy
sporing104319413sporing
sportif1238803sportif_
sportily1337733sportily
sporty115112493spor_ty
stonily1049433stonily
storey95217613stor_ey
storied8515163storied
stories7324273stories
storing83921123storing
stormily1345243stormily
stormy115510733stor_my
story86723033stor__y
strife95318363s_trife
stripy115812743s_tripy
surfy115319473s_ur_fy
terrify1336353terrify
torrify1335013torrify
verify153110163_verify
vitrify1645003vitrify

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 Filter1786911340270.453394461.4
2DLD Change Limit1340271566.25021444.3
3Display Results1561560.0632476.2
 (SQL Overall)1786911566.76626410.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.