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

133 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
canny10581769(None) 
candy115119821candy
canna75919331canna
canty105226801canty
carny105822921carny
cranny114210271cranny
fanny114816041fanny
nanny84813811nanny
anna45529012_anna
annoy869712_annoy
any68440482_a_ny
awny105919302_awny
bandy114824182bandy
banns75321232banns
banty106624002banty
barny105821732barny
benny105217362benny
bonny105816622bonny
branny115111832branny
bunny104715802bunny
cabby145314552cabby
caddy125414022caddy
cadgy125210782cadgy
cagey115917822cagey
cagy106321992ca_gy
cain65643912cain_
cains75334302cains
cairny11557822cairny
cakey145517272cakey
caky136222442ca_ky
campy145116182campy
can57760132ca_n_
canal75428042canal
canary11314692canary
cane66653112ca_ne
caned85838092caned
caner75334772caner
canes75350372canes
canid85526342canid
canine83826702canine
caning94128622caning
cannas84518402cannas
canned95022062canned
cannel84216402cannel
canner84625982canner
cannery123610002cannery
cannie83819362cannie
cannily1239262cannily
cannon84514442cannon
cannot83616772cannot
canoe75627252canoe
canon74725302canon
canonry1235912canonry
canons85522062canons
canopy1337722canopy
cans65050842ca_ns
canso75019402canso
canst74932212canst
cant66362022ca_nt
canto74931012canto
cants77036942cants
carn66245432carn_
carney115315702carney
carns75937562carns
carry105823782carry
casky144512682casky
catty104520412catty
cavy125920002ca_vy
cay87155982ca__y
chancy164010862chancy
chanty145215822chanty
clanky15469072clanky
coney105932882coney
conky145818742conky
conn66229132conn_
conns75024232conns
cony96537832c_ony
corny106023272corny
cranky153910632cranky
crony105918672crony
dandy104416702dandy
fancy134615482fancy
fawny144711712fawny
fenny115115132fenny
finny114716752finny
funny114614832funny
ginny95314572ginny
granny104311162granny
gunny94413662gunny
handy125520872handy
hanky155418292hanky
hinny115616672hinny
janty156816962janty
jenny153811622jenny
lanky125517482lanky
lawny115912012lawny
mangy115021232mangy
manly105022942manly
manna75522532manna
many95731842ma_ny
minny104518662minny
nancy105214922nancy
ninny84514932ninny
pandy115021172pandy
panne76623652panne
pansy105717972pansy
panty105929302panty
penny105119452penny
pinny105222062pinny
punny104217712punny
rainy85921082rainy
randy95022082randy
rangy95320382rangy
runny84613482runny
sandy94221132sandy
scanty114014662scanty
shanny124110092shanny
sonny85016102sonny
sunny84917742sunny
swanny12336822swanny
tangy94519932tangy
tannoy958352tannoy
tansy84514932tansy
tawny114713652tawny
tinny85317652tinny
tranny94210862tranny
tunny86515032tunny
uncanny1245112uncanny
waney115120322waney
wanly115118022wanly
wany106432352wa_ny
wenny114412462wenny
zany167316982za_ny

Search took 4 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.0931921408.6
2DLD Change Limit538001333.43615657.7
3Display Results1331330.1261055.6
 (SQL Overall)1786911333.65548889.5
 
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.