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

100 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
capstans125724(None) 
capstan1137911capstan_
captans111612051cap_tans
cabstand1344412cabstand
cabstands1453732cabstands
caftans12179442ca_ftans
capelans1238012capelans
capitals12209452capitals
capstone1237652capstone
capstones1347372capstones
captains121810572cap_tains
captan101613342cap_tan_
abstains1047323_abstains
caesars9410733caes_ars
caestus947773caest_us
caftan111710123ca_ftan_
caimans113811783ca_imans
caissons1036283caissons
callans94518473ca_llans
canastas1037693canasta_s
cancans11311873ca_ncans
cantals93919573ca_ntals
cantons95221203ca_ntons
capelan1139013capelan_
capelins12311133capelins
capeskins1744073capeskins
capias10318353cap_ia_s
capita102913773capita__
capital112311523capita_l
capitate121712183capitate
capitols12247333capitols
caplins113515993cap_lins
capons104119503cap__ons
caporals1238923caporals
capotes11314643capot_es
capsicins1545173capsicins
capsids1239333caps_ids
capsizes2147203capsizes
capsules1236633capsules
captain112111063cap_tain
captions123813223captions
captors113914983cap_tors
caravans1338623caravans
caritas93316963carita_s
carotins102315583carotins
cartons94122473ca_rtons
casas75327843ca_s_a_s
casbahs1436463ca_sbahs
caseins93115053ca_seins
caserns94711223ca_serns
cashaws15398573ca_shaws
casitas93312043casita_s
cassatas1036683cassatas
cassenas10317483cassenas
cassias93514343cassia_s
cassinas103610643cassinas
castanet10416193ca_stanet
castanets1146343ca_stanets
casters94729903ca_sters
castes85631863ca_st_es
casting104628343ca_sting
castings113614053ca_stings
castles94917733ca_stles
castors94919443ca_stors
casts77237793ca_st__s
casuals91410543ca_suals
caterans10313223caterans
catspaws1543163catspaws
causals91411183caus_als
caustics1237483caustics
caymans14349513ca_ymans
cestas85018543c_esta_s
chastens13429183chastens
constant10515593constant
constants11410913constants
costars94218013c_ostars
cotans81317923c__otans
crystals1347173crystals
cuestas957933cuesta_s
cyprians1544213cyprians
darshans1286543darshans
daystars1243903daystars
fastens105511753fa_stens
habitans1346623habitans
haptens124511343hap_tens
hastens106214813ha_stens
japans1539823jap__ans
kaftans14185353ka_ftans
paesans93312693paes_ans
paisans93614753pais_ans
paphians1545593paphians
partans94418283pa_rtans
pastas85422873pa_sta_s
ratans63819373ra__tans
rattans73411953ra_ttans
sapotas939613sapota_s
tapsters10318803tapsters
tartans72615823ta_rtans
upstand1045343_upstand
upstands1144093_upstands

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 Limit1461621007.48319532.5
3Display Results1001000.0303333.3
 (SQL Overall)1786911007.93622516.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.