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

86 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
caftaned144509(None) 
caftan111710122caftan__
caftans12179442caftan_s
cantoned111411522cantoned
captained1446192captained
cartoned111312832cartoned
castanet10416192castanet
acetated112010683acetated
afeared1176833_afeared
affined1436413_affined
atoned75417543_a_toned
attained997353_attained
attuned835173_attuned
battened11259573battened
cabbaged1644383cabbaged
cabined1239993ca_bined
cabstand1344413cabstan_d
cairned1037643ca_irned
calcanea1276293calcanea
calcanei1265273calcanei
calcined1338743calcined
canaled103615563ca_naled
caned85838093c___aned
canned95022063ca__nned
cannoned11118143cannoned
canted94825783cant__ed
cantered113415983cantered
canvased14246223canvased
capitated14159043capitated
captan101613343captan__
captans111612053captan_s
captioned1445763captioned
captured1336573captured
caravaned1544993caravaned
carcanet12316353carcanet
careened1139193careened
cartage10312593cartage_
cartages11313313cartages
carted98631443cart__ed
cartooned1246313cartooned
cascaded14135703cascaded
caseated11310713caseated
castanets1146343castanets
castled104311513cast_led
castrated1239513castrated
catered103117773ca_tered
catface1436763catface_
catfaces1536963catfaces
catted95422473ca_t_ted
caudated1238063caudated
cautioned1245363cautioned
caveated1439133caveated
caverned1436163caverned
cavitated15177353cavitated
cayenned1443163cayenned
cetane8315283c_etane_
cetanes9315133c_etanes
chastened1545883chastened
chicaned1665873chicaned
cleaned103512003c_leaned
coffined1735993coffined
contained12310893contained
cottoned1138033cottoned
crafted13419773craft__ed
craned96121653c__raned
curtained1265503curtained
fastened12257853fastened
fattened12268283fattened
hafted134713833haft__ed
hastened12239103hastened
kaftan13185823kaftan__
kaftans14185353kaftan_s
lactated1138873lactated
latened8711923la_tened
patined105114783pa_tined
pattened11299393pattened
rafted104714703raft__ed
raftered1237663raftered
rattened9218623rattened
softened1235663softened
staned74824643__staned
tautened935423tautened
waftage14115323waftage_
waftages15105393waftages
wafted134012143waft__ed
wantoned12117223wantoned

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.423422437.4
2DLD Change Limit146162867.48319532.5
3Display Results86860.0332606.1
 (SQL Overall)178691867.93922508.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.