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

140 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
canoe7562725(None) 
cane66653121can_e
canoed94618961canoed
canoer85121071canoer
canoes84725881canoes
canon74725301canon
acne66625872acn_e
acnode938202acnode
aloe45540192_aloe
ane37866952_an_e
anoa45634472_anoa
anode65021042_anode
anole55330382_anole
anon46134852_anon
ante46538902_ante
bane65250432ban_e
cable95329912cable
cabob114616812cabob
cache125122482cache
cade76443912ca_de
cadge94018792cadge
cadre85419022cadre
cafe95230322ca_fe
cage75339062ca_ge
cahow135110942cahow
cajole154011182cajole
cajon144513902cajon
cake105439962ca_ke
calo64936442calo_
calos74431902calos
calve105919922calve
came87648752ca_me
cameo95924992cameo
camo85731752camo_
camos95927612camos
can57760142can__
canal75428042canal
canape10913512canape
cancel105316682cancel
cancer104220922cancer
candle94321482candle
candor94516422candor
candy115119822candy
caned85838092caned
caner75334772caner
canes75350372canes
cangue91012442cangue
canid85526342canid
canine83826702canine
canker124422522canker
canna75919332canna
canned95022062canned
cannel84216402cannel
canner84625982canner
cannie83819362cannie
cannon84514442cannon
cannot83616772cannot
canny105817692canny
canoers94318372canoers
canola8313622canola
canons85522062canons
canopy1337722canopy
cans65050852can_s
canso75019402canso
cansos84915382cansos
canst74932212canst
cant66362032can_t
canted94825782canted
canter85230112canter
cantle84522152cantle
canto74931012canto
canton85722992canton
cantor85621522cantor
cantos84826972cantos
cants77036942cants
canty105226802canty
canyon114512032canyon
canzone1858812canzone
cape87242782ca_pe
capo85829212capo_
capon95221872capon
capos94826072capos
capote10315732capote
care66968372ca_re
carle74535702carle
carnie84421092carnie
carob95325222carob
carol75128612carol
carom95025562carom
carse74934332carse
carte75940422carte
carve106227752carve
case65848082ca_se
caste75932362caste
cate66254602ca_te
cause75225352cause
cave95941262ca_ve
cavie104621592cavie
cenote83715842cenote
cense75121402cense
chance134617092chance
change124116752change
cine66242942cin_e
clone75728162clone
cone67256962con_e
conge85227592conge
conte76633202conte
crane75331602cran_e
crone75231332crone
cyano105512492cyano_
dance85223132dance
fane75343572fan_e
fano75831692fano_
fanon84619012fanon
fanos85926502fanos
gane55145302gan_e
ganof95420362ganof
hance105424152hance
hanse85722792hanse
jane115031482jan_e
kane85133972kan_e
lance75126722lance
lane45153332lan_e
lanose6313592lanose
mahoe10315572mahoe
mane65052032man_e
mange84930192mange
mano66536812mano_
manor78023932manor
manos74933622manos
manse75528232manse
nance74721842nance
pane64950292pan_e
panne76623652panne
rance75028512rance
ranee55438102ranee
range64728412range
sane45954342san_e
vane75534692van_e
wane76344722wan_e

Search took 2 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.313570897.8
2DLD Change Limit538001401.45337026.8
3Display Results1401400.0463043.5
 (SQL Overall)1786911401.81298615.3
 
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.