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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

128 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
cadasters123683(None) 
cadaster1136901cadaster_
cadastres1244551cadastres
adapters1136102_adapters
cadastre1144282cadast_re
cadavers1435892cada_vers
canisters112310202canisters
casters94729902c__asters
coasters104317342c_oasters
cytasters1483672cytasters
abasers95311973_abas_ers
abaters95115203_aba_ters
adapter1036173_adapter_
adaptors1145263_adaptors
adjusters1744163_adjusters
adopters1136693_adopters
alabasters1243253alabasters
alastors8311223_alastors
amassers10337843_amassers
asters65631603___asters
awaiters1146643_awaiters
badasses1136173badasse_s
ballasters1245093ballasters
balusters1136643balusters
bandmasters1684183bandmasters
banisters11189473banisters
basters94930303__basters
blasters104116143_blasters
boasters103915663_boasters
cadastral1243073cadastral
cadaver1335793cada_ver_
cadgers114712003cad__gers
calashes13310543calashe_s
calypters1643593calypters
camases114216343camas_e_s
camasses12388973camasse_s
canallers1137213canallers
canastas1037693canast_as
canistels11205393canistels
canister101710853canister_
cannisters1245023cannisters
canters94827733c__anters
canvasers14265363canvas_ers
canvassers15273583canvassers
carates95630613cara_te_s
caressers1137443caressers
carters95327253c__arters
caster85232573c__aster_
castes85631863c__aste_s
castors94919443c__astors
caters85336503c__a_ters
catheters1437013catheters
caudates11310263cauda_te_s
causers94014793ca_us_ers
cavaliers1455623cavaliers
cavorters1434973cavorters
cerastes101111093ceraste_s
chanters134016743c_hanters
chapters154012133c_hapters
characters1745503characters
charters134115583c_harters
chasers123714923c_has_ers
chastens13429183c_hastens
chaster124718503c_haster_
chatters134213953c_hatters
cheaters133613513chea_ters
clashers134213993c_lashers
claspers124410913c_laspers
classers104111833c_lassers
clatters103313913c_latters
cloisters1137443cloisters
clusters102912403c_lusters
clysters13227843c_lysters
coaster94219043c_oaster_
coaters93525793c_oa_ters
copastors1346993copastors
costers94128343c__osters
crafters13419953c_rafters
crashers134013233c_rashers
craters95021893c_ra_ters
creasers103612843creas_ers
cytaster1383863cytaster_
dabsters1137053da_bsters
darters84017603__darters
dashers115016863__dashers
daters74827373__da_ters
diasters92913183_diasters
disasters1039153disasters
dusters84918363__dusters
easters75125683__easters
feasters11511563_feasters
gagsters10317083ga_gsters
gamesters1236733gamesters
gangsters11205733gangsters
ganisters10248313ganisters
gasters85624293__gasters
hamsters13710423ha_msters
harassers1246203harassers
headmasters17174303headmasters
lamisters1157123lamisters
lamsters1099753la_msters
lasters75627693__lasters
loadmasters1453313loadmasters
magisters1235803magisters
maltsters1135193maltsters
masters94628923__masters
oldsters996733old_sters
oleasters936733oleasters
pasters94531733__pasters
paymasters1743843paymasters
piasters102912813_piasters
pilasters1138223pilasters
pinasters1136823pinasters
plasters103518133_plasters
radwastes1364123radwaste_s
rasters74629023__rasters
remasters11310583remasters
roadsters1035103road_sters
roasters83615933_roasters
scamsters1334993sca_msters
tapsters10318803ta_psters
tasters74225643__tasters
teatasters1043883teatasters
toasters83912723_toasters
updaters11255183upda_ters
waisters113811523wa_isters
wasters104026593__wasters
yardmasters1752733yardmasters

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 Filter1786911486410.453394461.4
2DLD Change Limit1486411288.03018510.7
3Display Results1281280.0632031.7
 (SQL Overall)1786911288.54620909.3
 
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.