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

130 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
canal7542804(None) 
anal48037521_anal
banal75925991banal
cabal95222151cabal
canals84421661canals
cantal84122031cantal
carnal83919201carnal
aal39058672_a_al
ana39559822_ana_
anas46649862_anas
anil46437432_anil
annal56520762annal
axal116520492_axal
baal67033112ba_al
basal75722282basal
binal75323822binal
cabala103516912cabala
cabals104020152cabals
caca85528082caca_
cacao95420002cacao
cacas95627982cacas
caecal103713732caecal
call66838672ca_ll
calla74827072calla
camail10314822camail
camas96333522camas
camel96822802camel
can57760132can__
canaled103615552canaled
canape10913512canape
canard9314762canard
canary11314692canary
cancan10314102cancan
cancel105316682cancel
candle94321482candle
candy115119822candy
cane66653112can_e
caned85838092caned
caner75334772caner
canes75350372canes
canful11610262canful
canid85526342canid
canna75919332canna
cannas84518402cannas
cannel84216402cannel
canny105817692canny
canoe75627252canoe
canola8313622canola
canon74725302canon
cans65050842can_s
canso75019402canso
canst74932212canst
cant66362022can_t
cantala94114672cantala
cantals93919572cantals
canthal12410052canthal
cantle84522152cantle
canto74931012canto
cants77036942cants
canty105226802canty
canula8312952canula
canvas113813332canvas
carat75048792carat
carinal94318222carinal
carl65144782ca_rl
carol75128612carol
carpal103716252carpal
casa65630862casa_
casas75327842casas
casual81112862casual
catalo8314852catalo
catnap1098382catnap
caudal91611482caudal
caul65630002ca_ul
causal81413202causal
cavil103816492cavil
cecal94619112cecal
cental84420962cental
clinal8311552clinal
clonal8310912clonal
coal66939252c_oal
coaxal15387302coaxal
comal95125132comal
copal95621782copal
coral76033452coral
coxal146116672coxal
craal74117752craal
cranial92114682cranial
cuneal8611512cuneal
decanal1038112decanal
fatal84819372fatal
faunal94711592faunal
final83922032final
gayal9312712gayal
hadal95518122hadal
halal85623592halal
hamal104623102hamal
jacal14313702jacal
kana85928522kana_
kanas95326912kanas
lanai5319572lanai
mana65341942mana_
manas76240422manas
manat76039982manat
manual8313462manual
nana46632892nana_
nanas55928632nanas
nasal56217592nasal
natal53921492natal
naval85315832naval
panel76023622panel
papal95820672papal
penal75228372penal
qanat144426842qanat
ramal74622242ramal
ratal55025112ratal
renal55929502renal
sabal75422482sabal
salal55425702salal
sandal73317282sandal
scandal1038672scandal
tamal73522612tamal
tarnal63716502tarnal
tonal53724302tonal
vagal94613632vagal
vandal103713832vandal
vasal85516292vasal
venal85523212venal
vinal85725812vinal
zonal145116852zonal

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 Limit538001302.39022510.5
3Display Results1301300.0462826.1
 (SQL Overall)1786911302.60668569.1
 
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.