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

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

134 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
clary10571961(None) 
alary86123441alary
chary135023131chary
claro75018691claro
clay95927411cla_y
glary96018541glary
alar46340072alar_
alarm76621422alarm
blare75826232blare
bleary115112552bleary
cagy106321992c_agy
caky136222442c_aky
calory11312842calory
calvary1537182calvary
canary11314692canary
car59165562c_ar_
carb85143162c_arb
card710245872c_ard
care66968372c_are
cark105539272c_ark
carl65144782c_arl
carn66245432c_arn
carny105822922c_arny
carp85139812c_arp
carr65434702c_arr
carry105823782carry
cars67364762c_ars
cart66570342c_art
cavy125920002c_avy
cay87155982c_a_y
cedary12419602cedary
celery1139622celery
char95132152char_
chard116124742chard
chare105231982chare
chark144222712chark
charm126124662charm
charr104821782charr
charry145012112charry
chars105936632chars
chart105038282chart
chay124924872cha_y
ciliary1247922ciliary
clach124617822clach
clack134720172clack
clad76225822cla_d
clade85821012clade
clads85722732clads
clag75924572cla_g
clags85621122clags
claim95616912claim
clam86332292cla_m
clammy15356332clammy
clamp115517652clamp
clams95127672clams
clan65633922cla_n
clang86019312clang
clank114719522clank
clanky15469072clanky
clans75031012clans
clap86429042cla_p
claps95626182claps
clapt98027172clapt
claret84026572claret
clarify1536092clarify
clarity12310912clarity
claros84015112claros
clash106219032clash
clasp95517192clasp
class75525482class
classy11379042classy
clast76030582clast
clave105420152clave
clavi104912922clavi
claw95624342cla_w
claws106020832claws
clayey14407662clayey
clays105521332clays
clear76219052clear_
clearly1236662clearly
clears84116562clears
clergy1234992clergy
clerk115812452clerk
cloy96623832cl_oy
coaly105521592coaly
cory96941512c_ory
covary1438742covary
cowry135512482cowry
crazy195511222crazy
cry89726242c__ry
curry105920342curry
czar156013132czar_
czars164812912czars
deary95826842deary
diary95016972diary
flaky155715582flaky
flamy135217472flamy
flare84823632flare
flawy145913382flawy
flaxy189012292flaxy
flay106332802fla_y
glady105413942glady
glairy10448272glairy
glare65222952glare
glazy187410982glazy
glory96413292glory
hoary114516762hoary
lacy95829632_lacy
lady86527152_lady
laky116725822_laky
lar37967532_lar_
lard56742002_lard
lardy96119272_lardy
lari45839152_lari
lark85733862_lark
larky125218872_larky
lars46956572_lars
lay68865352_la_y
lazy166423072_lazy
leary85927382leary
lory75931712_lory
nary76931222_nary
ovary1149112ovary
platy105021662platy
play95928982pla_y
salary9515212salary
scary105222592scary
slaty86523152slaty
slay76436382sla_y
teary85124052teary
unary8315992unary
vary105226062_vary
wary106740012_wary
weary115620612weary

Search took 3 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 Filter178691538000.1701051123.5
2DLD Change Limit538001342.31323259.8
3Display Results1341340.0632127.0
 (SQL Overall)1786911342.54670185.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.