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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

52 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
cannonading155238(None) 
cannoning1237322cannon__ing
annotating1146233_annotating
cannonade12123953cannonad__e
cannonaded14152733cannonad_ed
cannonades13143823cannonad_es
cannonballing1812873cannonballing
cannulating1446013cannulating
canonising1346583ca_nonising
canonizing2247713ca_nonizing
cantoning12310883canton__ing
canyoning1536873canyon__ing
carbonadoing1851383carbonadoing
carbonating1645863carbonating
gasconading1652013gasconading
accolading1644794_accolading
annealing1047454_ann_ealing
announcing1342994_announcing
annoying1246544_anno__ying
bastinading1573554bastinading
canaling112016414ca___naling
cannabin1266434ca_n_nabin_
cannabins1365784ca_n_nabins
canning103620134ca_n_n__ing
cannoned11118144cannoned___
cannonries1244094cannon_ries
canoeing11310214ca_no__eing
canoodling1443584ca_noodling
canopying1745064ca_no_pying
canulating1349554ca_nulating
canvasing1546434ca_n_vasing
canyonings1642874canyon__ings
caponizing2446984ca_ponizing
carbonizing2545864carbonizing
cartoning12311114carton__ing
cascading1545674ca__scading
catenating1348684ca_tenating
condoning1339784condon__ing
confounding1843264confounding
connoting12310024conno__ting
contending1449124conten_ding
coronating13410174c_oronating
fanfolding1842744fanfo_lding
innovating1444614_innovating
intonating1148634_intonating
lancinating1445454lancinating
marinading1445614ma_rinading
nonbonding1445034nonbon_ding
nonfading1445874__nonfading
onloading1145164_onlo_ading
unloading1137194_unlo_ading
wantoning1337084wanton__ing

Search took 9 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 Filter1786911488190.440406115.9
2DLD Change Limit148819528.50017508.1
3Display Results52520.0301733.3
 (SQL Overall)178691528.97019921.0
 
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.