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

97 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
chantage144663(None) 
chantages1546581chantages
cartage10312592c_artage
chaetae1238602chaeta_e
change124116752chan__ge
chantable1636892chantable
thanage11117932than_age
vantage11109892_vantage
wantage11119622_wantage
advantage1452183advantage
anlage72514223__anlage
antae56828293__anta_e
apanage1036803apan_age
bandage11311023_bandage
cabbage1446983c_abbage
cabotage1345223cabotage
canape10913513c_an_ape
cantal84122033c_anta_l
cantala94114673c_antala
cantals93919573c_antals
cantata93811813c_antata
cantle84522153c_ant_le
carnage10311743c_arnage
cartages11313313c_artages
centare93113703c_entare
chaeta11310683chaeta__
chaetal1238283chaeta_l
chamade15138433cha_made
champagne1942783champagne
chance134617093chan__ce
chancre14348783chan_cre
chang115418563chan__g_
changed144214143chan__ged
changer134215543chan__ger
changes134517583chan__ges
changs125215373chan__gs
chant105932693chant___
chanted134015953chant_ed
chanter123919733chant_er
chanters134016723chanters
chanteuse1443473chanteuse
chantey154112543chant_ey
chanteys16387493chanteys
chanties132615803chanties
chanting143413533chanting
chantor123710313chant_or
chantors133710253chantors
chantries14310273chantries
chantry15388213chant_ry
chants115020393chant__s
chanty145215823chant__y
charade13129903cha_rade
charge125114213cha__rge
chartable1636833chartable
chaste114617393chast__e
chastise1348173chastise
chinwag1643533chinwag_
chinwags1743373chinwags
choanae1236863choan_a_e
clientage1242713clientage
coinage10310553coin_age
comanage1346343coman_age
cottage104210573c_ottage
craniate10312563craniate
crannoge1144263crannoge
cuttage10318343c_uttage
cyanate12259703cyan_ate
frontage1296243frontage
graftage1343683graftage
hangtag1244513_hangtag_
hangtags1344153_hangtags
hantle94318203_hant_le
hastate10313913_hastate
haulage1136913_haulage
haylage1436443_haylage
hostage113111233_hostage
khanate1437073khan_ate
manage93818903_man_age
mintage101110123_mintage
montage101211713_montage
phantasm1554123phantasm
phantast1346923phantast
phantasy1643463phantasy
shortage1236303shortage
tankage12257773_tankage
tannage8209583_tannage
tentage81010643_tentage
thanages12107603than_ages
thenage11107833then_age
vantages12119023_vantages
ventage11109623_ventage
vintage11128143_vintage
waftage14115323_waftage
wantages12109023_wantages
wastage11109253_wastage
wattage1186983_wattage
wharfage1842213wharfage

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 Filter1786911461620.1561145455.1
2DLD Change Limit146162978.08018089.4
3Display Results97970.0462108.7
 (SQL Overall)178691978.28221575.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.