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

65 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
cantabile134689(None) 
cantabiles1445761cantabiles
cartable121314092cartab_le
castable121613972castab_le
chantable1636892chantab_le
actable11313473_actab_le
bankable1677913bankab_le
bannable1278353bannab_le
callable12310753callab_le
campanile1544403campanile
canaille1048413can_aille
canalise10816213can_alise
canalize19914493can_alize
cannabic1474913cannabi_c
cannabin1266433cannabi_n
cannabins1365783cannabins
cannabis1266033cannabi_s
cannabises1444433cannabises
canoeable1347103canoeab_le
cantal84122033canta__l_
cantala94114673canta__la
cantals93919573canta__ls
cantatrice1463463cantatrice
canticle1239703cant_icle
cantle84522153cant___le
capable13313363ca_pab_le
carabine12412393ca_rabine
cascable141510623cascab_le
cashable15159793cashab_le
catamite12510593ca_tamite
cattail939183catta_il_
cattails1038553catta_ils
causable1239973causab_le
centile94217183cent__ile
chartable1636833chartab_le
citable11313463c_itab_le
constable13311003constab_le
countable1348853countab_le
cuttable1247953cuttab_le
datable101714233da_tab_le
eatable91717603ea_tab_le
fantail10310233fanta_il_
fantailed1345563fanta_iled
fantails1139693fanta_ils
fantasie11117743fantasi_e
fantasise1296243fantasise
fantasize2196053fantasize
grantable1257293grantab_le
hangable1438213hangab_le
hatable121713963ha_tab_le
huntable1338093huntab_le
paintable1337243paintab_le
pantile93918483pant__ile
plantable1337273plantab_le
ratable91717553ra_tab_le
rentable101716333rentab_le
sandable111612823sandab_le
scannable1345643scannab_le
stabile9312063__stabile
tannable1039383tannab_le
tantalise91210823tantalise
tantalite91010863tantalite
tantalize181010573tantalize
tastable101511973tastab_le
wastable131410453wastab_le

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 Filter1786911486410.453394461.4
2DLD Change Limit148641657.26620457.1
3Display Results65650.0331969.7
 (SQL Overall)178691657.75223051.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.