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

89 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
cytasters148366(None) 
cytaster1383861cytaster_
cadasters1236832cadasters
casters94729902c__asters
coasters104317332c_oasters
tasters74225642__tasters
asters65631603___asters
attesters935803attesters
basters94930303__basters
betatters1134963betatters
blasters104116143_blasters
boasters103915663_boasters
cadaster1136903cadaster_
cadastres1244543cadastres
canisters112310193canisters
canters94827733c__anters
carters95327253c__arters
caster85232573c__aster_
castes85631863c__aste_s
castors94919443c__astors
caters85336503c__a_ters
catheters1437013catheters
cerastes101111093ceraste_s
chanters134016743c_hanters
chapters154012133c_hapters
charters134115583c_harters
chasers123714923c_has_ers
chastens13429183c_hastens
chaster124718503c_haster_
chatters134213953c_hatters
cheaters133613513chea_ters
citators10310253cita_tors
clashers134213993c_lashers
claspers124410913c_laspers
classers104111833c_lassers
clatters103313913c_latters
cloisters1137433cloisters
clusters102912403c_lusters
clysters13227843c_lysters
coaster94219043c_oaster_
coaters93525793c_oa_ters
contesters12410183contesters
copastors1346993copastors
costers94128333c__osters
cotters94323443cot__ters
crafters13419953c_rafters
crashers134013233c_rashers
craters95021893c_ra_ters
creasers103612823creas_ers
cutters94218963cut__ters
cutwaters1443613cutwaters
cycases1437533cycas_e_s
detesters10298303detesters
diasters92913183_diasters
disasters1039153disasters
easters75125683__easters
feasters11511563_feasters
gasters85624293__gasters
gypsters1434023gy_psters
lasters75627693__lasters
masters94628923__masters
oleasters936733oleasters
outmasters1245733outmasters
oysters103411693oy__sters
pasters94531733__pasters
paymasters1743843paymasters
piasters102912813_piasters
pilasters1138223pilasters
pinasters1136823pinasters
plasters103518133_plasters
poetasters1245283poetasters
rasters74629023__rasters
remasters11310583remasters
retastes82212903retaste_s
roasters83615933_roasters
spymasters1742803spymasters
starters83714773_starters
staters73922343_sta_ters
tapsters10318803__tapsters
taster64930573__taster_
tastes64126423__taste_s
taters64932203__ta_ters
tatters74520483__tatters
teatasters1043883teatasters
testers74124543__testers
toasters83912723_toasters
wasters104026593__wasters
xysters17307163xy__sters
yatters103914623_y_atters

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.1561145455.1
2DLD Change Limit148641897.20320636.0
3Display Results89890.0302966.7
 (SQL Overall)178691897.38924183.4
 
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.