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

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

87 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
cantdogs124404(None) 
cantdog1134571cantdog_
bandogs1138362ban_dogs
candors104216762can_dors
cantons95221202cant_ons
cantors94620752cant_ors
cantos84826972cant_o_s
hangdogs1443602hangdogs
acanthous1444423acanthous
analogs82810453_analogs
antilogs949603_antilogs
antings85015583_antings
bandog1038723ban_dog_
bantengs1134593bantengs
caltrops12307863caltrops
candids113812693can_dids
candies104125613can_dies
candles104422343can_dles
candor94516423can_do_r
candour104210243can_dour
candours11408643can_dours
canids95118133canid__s
cannings113710333cannings
cannons94412883can_nons
canoes84725883can__oes
canons85522063can__ons
canorous10310193canorous
cansos84915383can_so_s
cantalas104013523cantalas
cantals93919573cant_als
cantatas103410093cantatas
canteens1038573canteens
canters94827733cant_ers
canthus1248713cant_hus
cantinas102713773cantinas
canting104725903canting_
cantles94721413cant_les
canto74931013cant_o__
canton85722993cant_o_n
cantor85621523cant_o_r
cantraps12319113cantraps
cantrips12318933cantrips
cants77036943cant___s
cantus85117763cant__us
canyons124511593can_yons
captions123813223captions
captious122810573captious
captors113914983capt_ors
cardons104519933ca_rdons
cartons94122473cart_ons
cartoons104012803cartoons
castings113614053castings
castors94919443cast_ors
catalogs1148033catalogs
cations94524143ca_tions
cautions103313183cautions
cautious103110233cautious
centos85920463cent_o_s
chantors133710263chant_ors
condoes104319203con_does
condoms124214083con_doms
condors104018573con_dors
condos94322333con_do_s
contos84923233cont_o_s
controls10311393controls
coydogs1434493c_oydogs
crannogs1143783cran_nogs
fandoms13229473fan_doms
fantods11177623fant_ods
fantoms12189153fant_oms
gundogs1034603gun_dogs
hangdog1343133hangdog_
hotdogs1234453_hotdogs
lapdogs1134073la_pdogs
pantos85222743pant_o_s
randoms102112433ran_doms
saintdoms1242493saintdoms
sandhogs1365483sandhogs
santols73513323sant_ols
santoors837633santoors
santos64421833sant_o_s
sundogs947103sun_dogs
tautogs875413taut_ogs
vanadous1246033vanadous
wantons103713013want_ons
warthogs1544823warthogs
xanthous1846643xanthous

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.440406115.9
2DLD Change Limit146162876.51322441.6
3Display Results87870.0332636.4
 (SQL Overall)178691876.98625578.4
 
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.