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

157 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
clarify153609(None) 
clarity12310911clarity
calcify1735872calcify
carnify1555882c_arnify
charily15310282charily
charity15311022charity
claries93422202claries
clarion9311662clarion
clary105719612clar__y
classify1644692classify
clerisy1246822clerisy
coalify1536682coalify
glorify1444582glorify
rarify123210062_rarify
scarify1537442scarify
aerify122810113_aerify
alacrity1355483alacrity
alary86123443alar__y
alkalify1842823alkalify
basify1437513_basify
beatify1536593beatify
blaring104317113blaring
blarney12174763blarney
blearily1365953blearily
cagily12411563c_agily
cairny11557823c_airny
calamity1547753calamity
calif104929103c_alif_
califs114915893c_alifs
carafe115416163c_arafe
carboy134914183c_arboy
caribe103416753c_aribe
caried94528693c_aried
caries85147623c_aries
carina84325323c_arina
caring95137993c_aring
carney115315703c_arney
carny105822923c_ar_ny
carry105823783c_ar_ry
casefy1436273c_asefy
cavity14310013c_avity
celerity1347643celerity
certify1546243certify
chaffy20456473cha_ffy
charier124317903charier
charing133721323charing
chariot12316213chariot
charism14712203charism
charley15118273charley
charpoy1735713charpoy
charry145012113char_ry
chary135023133char__y
citify1437443c_itify
cladism1238553cladism
cladist10311973cladist
claim95616913cla_i_m
claims105211573cla_ims
clammily1743633clammily
clammy15356333cla_mmy
clanky15469073cla_nky
claret84026573clar_et
clarets94111103clarets
clarified1546973clarified
clarifier1446123clarifier
clarifies1448633clarifies
clarifying1944853clarifying
clarinet10317293clarinet
clarions10310493clarions
clarkia1334873clarkia
clarkias1444793clarkias
claro75018693clar__o
claroes93113733claroes
claros84015113clar_os
classily1336623classily
classy11379043cla_ssy
clavi104912923clavi__
clavier1239173clavier
clawing133812673clawing
clay95927413cla___y
clayey14407663cla_yey
clayier1248323clayier
claying133614303claying
clayish1547943clayish
clearing113014883clearing
clearly1236663clear_ly
clergy1234993cler_gy
cleric10612133cleri_c
clerics1149333clerics
clerid9312413cleri_d
clerids1049093clerids
clerkly1643573clerkly
cliff135917133cl__iff
cliffy17435243cl_iffy
clift106422193cl__ift
codify1537163c_odify
copurify1843053copurify
cornify1536253cornify
crazily2136923crazily
crucify1744063crucify
czarina1845953czarina
czarism2056423czarism
czarist18710223czarist
falsify1643613falsify
flakily1736293flakily
flaring114116803flaring
gasify1336333_gasify
glairy10448273gla_iry
glarier84112203glarier
glaring93714883glaring
glary96018543glar__y
glazily2035383glazily
gratify1436113gratify
hilarity1447173hilarity
hoarily1338973hoarily
horrify1635023horrify
lacily11612763_lacily
laity85318903_la_ity
lardy96119273_lar_dy
lari45839153_lari__
lariat6629043_lariat
larine63927043_larine
laris54737463_lari_s
larky125218873_lar_ky
laxity1637273_laxity
lazily1859713_lazily
metrify1535623metrify
micrify1744693micrify
molarity13118903molarity
nazify2134233_nazify
nigrify1444133nigrify
nitrify1335793nitrify
opacify1743653opacify
pacify1667473_pacify
parity114719873_parity
petrify1536573petrify
polarity131310403polarity
purify14399153_purify
qualify2235473qualify
ramify14268753_ramify
rarefy12296343_rarefy
rarity93615493_rarity
ratify122610043_ratify
salify12311373_salify
salsify1334703salsify
scarily12311703scarily
scorify1535203scorify
sharif122917123sharif_
sharifs13279903sharifs
tariff12711363_tariff
tearily10311153tearily
terrify1336353terrify
torrify1335013torrify
unclarity1445363unclarity
verify153110163_verify
vitrify1645003vitrify
warily122915093_warily
wearily1338783wearily

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.1401276364.3
2DLD Change Limit1340271577.44018014.4
3Display Results1571570.0632492.1
 (SQL Overall)1786911577.64323379.7
 
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.