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

184 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
canner8462598(None) 
banner84421501banner
cancer104220921cancer
caner75334771ca_ner
canker124422521canker
canned95022061canned
cannel84216401cannel
canners93822661canners
cannery123610011cannery
cannier94014161cannier
canoer85121071canoer
canter85230111canter
conner84423961conner
cunner83915001cunner
fanner94218181fanner
lanner64920601lanner
manner84020511manner
panner84224761panner
scanner94411811scanner
tanner63722291tanner
vanner94215841vanner
wanner94019621wanner
anger66225882_anger
annex12310882_annex
bander93928222bander
banger94423642banger
banker124222732banker
banned94721342banned
banners94018712banners
bannet84925332bannet
banter84825342banter
branner94212372branner
caber95126832ca_ber
cabler104519172cabler
cadger105013912cadger
cager85229222ca_ger
cagier93715932cagier
cahier113615772cahier
cakier123115242cakier
calker124917082calker
caller85125482caller
calmer105216932calmer
camber124418482camber
camper124722212camper
cancel105316682cancel
cancers114018582cancers
candler103516592candler
candor94516422candor
cane66653122ca_ne_
caned85838092ca_ned
caners84629202ca_ners
canes75350372ca_nes
canine83826702canine_
canines93724032canines
cankers134418752cankers
canna75919332cann_a
cannas84518402cannas
cannels93413362cannels
cannie83819362cannie
cannon84514442cannon
cannot83616772cannot
canny105817692cann_y
canoe75627252canoe_
canoed94618962canoed
canoers94318372canoers
canoes84725882canoes
canted94825782canted
canters94827732canters
cantor85621522cantor
caper94831622ca_per
capper124421982capper
carder94524182carder
career85822242career
carer74942332ca_rer
carnet84732872carnet
carney115315702carney
carper104923632carper
carter84932272carter
carver114420152carver
caster85232572caster
cater74840722ca_ter
causer84117782causer
caver105629062ca_ver
censer84516582censer
center84421412center
centner946852centner
chancer144215632chancer
changer134215542changer
channel123910492channel
chanter123919732chanter
cinder94119122cinder
clanger104113492clanger
cloner84418092cloner
coannex1635512coannex
coiner84323782coiner
confer114018682confer
conger95024272conger
conker124721552conker
conned95119702conned
conners94023112conners
corner84625622corner
cranker133612792cranker
cunners93913472cunners
damner95213432damner
dancer94817612dancer
dander811222992dander
danger83722832danger
danker114319662danker
darner74017302darner
dinner74217162dinner
dunner73913822dunner
earner63617222earner
fainer94717242fainer
fanned104117472fanned
fanners103914652fanners
fawner125910462fawner
funner93414102funner
gainer74117492gainer
gander84322762gander
ganger83721472ganger
gannet74321852gannet
garner73917002garner
ginner73915822ginner
gunner73813982gunner
hander104526432hander
hanger104023262hanger
hanker134622092hanker
inaner62213542inaner
inner54920632_inner
lancer84319972lancer
lander74028492lander
lanker104123002lanker
lanners73618332lanners
manger94325012manger
manned94418642manned
manners93417832manners
pander93725532pander
panier84425502panier
panne76623652panne_
panned94123432panned
panners93621272panners
pannes85522852pannes
pannier93613352pannier
panzer174213232panzer
pawner114212922pawner
penner84616662penner
pinner84521502pinner
planner93511632planner
punner84918162punner
ranger73925532ranger
ranker105021902ranker
ranter63826822ranter
runner63814462runner
sander74828532sander
saner54334322sa_ner
sanger74524572sanger
scanned104110892scanned
scanners10379702scanners
scanter94215182scanter
scunner9358242scunner
sinner64320602sinner
spanner94312562spanner
tanker104521132tanker
tanned75219962tanned
tanners74018392tanners
tannery10388662tannery
tenner64117102tenner
tinner64119962tinner
tonner64819202tonner
vainer93714572vainer
vanned104614482vanned
vanners103612842vanners
wander104423712wander
wanier93920682wanier
wanker134219972wanker
wanned104318012wanned
wanter94423052wanter
warner93717222warner
winner94219932winner
wonner95114442wonner
yarner93313062yarner
yawner12428472yawner
zander163417112zander
zanier154314712zanier

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 Filter178691825510.346516448.0
2DLD Change Limit825511842.32635490.5
3Display Results1841840.0632920.6
 (SQL Overall)1786911842.73565334.9
 
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.