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

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

161 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
canaller103895(None) 
canalled1139571canalled
canallers1137211canallers
caballed1337162caballed
caballero1342882caballero
caller85125482c__aller
canaille1048412canaille_
canailles1148272canailles
canaled103615552cana_led
canceler12238912canceler
canceller1366682canceller
candler103516592can_dler
capabler1435352capabler
caroller1039202caroller
catcaller1344812catcaller
cavalier1348172cavalier
caviller1337062caviller
anally9513503_anall_y
analyser11166133_analyser
analyzer20155053_analyzer
angler74017863_an_gler
antler64615553_an_tler
baller83825203__baller
banally1249223banall_y
caballeros1442033caballeros
cabler104519173c__abler
cackler153812573ca_ckler
cadaster1136903cadaster
cadaver1335783cada_ver
cadelle1039923cadelle_
cadelles1139973cadelles
cajoler16398393ca_joler
calker124917083c__alker
called94126733c__alled
callee84327293c__allee
callers94221963c__allers
callet84536763c__allet
calmer105216933c__almer
camailed1336553camailed
cameleer1246033cameleer
canal75428043cana_l__
canaling112016413canaling
canalise10816213canalise
canalised12810913canalised
canalises11515493canalises
canalize19914493canalize
canalized21611693canalized
canalizes201113783canalizes
canalling1239553canalling
canals84421663cana_l_s
canape10913513cana_pe_
canapes111213083cana_pes
canaries10318943canaries
canceled13279393canceled
cancelers13247863cancelers
cancelled1456743cancelled
cancellers1445363cancellers
cancer104220923can__cer
candider1237343candider
candle94321483can_dle_
candled113815733can_dled
candlers114214103can_dlers
candles104422343can_dles
canella9310793canell_a
canellas10310563canellas
caner75334773can___er
canister101710853canister
canker124422523can__ker
canner84625983can__ner
cannier94014163can_nier
cannular1046283cannular
canoer85121073can__oer
canter85230113can__ter
cantle84522153can_tle_
cantles94721413can_tles
canulae9311183canulae_
canular9310323can_ular
canvaser13276553canvaser
canvasser14274253canvasser
capable13313363capable_
caracoler1346413caracoler
carnally1339513carnall_y
caroler93816753ca_roler
carolled1138823carolled
carollers1137703carollers
cataloes10311653cataloes
cataloger1265353cataloger
catalyzer2344453catalyzer
catcalled1444893catcalled
catcallers1443803catcallers
catnaper1294933catna_per
catnapper1562913catnapper
caulker13456893ca_ulker
cavalero1344763cava_lero
cavaliers1455613cavaliers
cavalla1257883cavall_a
cavallas1366843cavallas
cavallies1446393cavallies
cavally1588483cavall_y
caviler1249063ca_viler
cavilled1436733cavilled
cavillers1435613cavillers
cenacle1139123cenacle_
cenacles1238023cenacles
chandler14358373chan_dler
channeler1444603channeler
chiller124112183c_hiller
coaler84121713c_oa_ler
coalier93416183c_oalier
condoler113412123condoler
consoler102812613consoler
cradler102910513c_radler
crawler123510453c_rawler
crueller1056453crueller
cruller968753c_ruller
culler84322253c__uller
cupeller1256103cupeller
dandler94414273dan_dler
dangler96912813dan_gler
danglier1056753danglier
dialler848813_dialler
enabler9299363_enabler
faller94621233__faller
finagler12194953finagler
ganglier1047603ganglier
gasalier936443gasalier
hanaper1237133hana_per
handler113516163han_dler
jangler153811833jan_gler
janglier1656113janglier
knoller11285903_knoller
labeller10248073labeller
landler84113203lan_dler
lavalier1146043lavalier
manacle11310283manacle_
manacled1336453manacled
manacles1239523manacles
manager103413583mana_ger
mangler103215643man_gler
manille92613273manille_
manilles102312603manilles
manlier92414023man_lier
nailer64119363__nailer
panelled1138963panelled
parallel1047463parallel
pedaller1136093pedaller
raveller11339263raveller
recaller1039323recaller
sandalled1145903sandalled
scandalled1443073scandalled
signaller1043693signaller
smaller93410333_smaller
snarler73610633_snarler
sneller73512843_sneller
spaller92713473_spaller
squaller1736083squaller
taller63721963__taller
tanager83010943tana_ger
tangler83515073tan_gler
tanglier948073tanglier
wangler113312653wan_gler

Search took 8 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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621617.26620115.9
3Display Results1611610.0762118.4
 (SQL Overall)1786911617.49823831.8
 
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.