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

108 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
cytaster138386(None) 
cytasters1483661cytasters
cadaster1136902cadaster
caster85232572c__aster
chaster124718502c_haster
coaster94219042c_oaster
taster64930572__taster
aster55434893___aster
attester836503attester
baster85333593__baster
betatter1035453betatter
blaster94017303_blaster
boaster94616433_boaster
cadasters1236833cadasters
cadastre1144273cadastre
canister101710853canister
canter85230113c__anter
carter84932273c__arter
caste75932363c__aste_
casters94729903c__asters
castes85631863c__astes
castor84418533c__astor
cater74840723c__a_ter
catheter1338153catheter
cerastes101111093cerastes
chanter123919733c_hanter
chapter144213853c_hapter
charter123918303c_harter
chaser114918383c_has_er
chaste114617393c_haste_
chasten124312403c_hasten
chatter124416643c_hatter
cheater124816963chea_ter
citator9310123cita_tor
clasher124615513c_lasher
clasper113811863c_lasper
classer93614613c_lasser
clatter94014973c_latter
cloister1037093cloister
cluster94013333c_luster
clyster12317453c_lyster
coasted104015953c_oasted
coasters104317333c_oasters
coater84329573c_oa_ter
contester11311183contester
copastor1246343copastor
coster84331293c__oster
cotter84926673cot__ter
crafter124111333c_rafter
crasher124616163c_rasher
crasser94114343c_rasser
crater85026643c_ra_ter
creaser94415743creas_er
creasier103210193creasier
cutesier1045623cutesier
cutter84521003cut__ter
cutwater1344833cutwater
cycases1437533cycas_es
detester9239683detester
diaster82813313_diaster
disaster949943disaster
easter65027983__easter
faster94625773__faster
feaster10812983_feaster
gaster75027353__gaster
gypster1333953gy_pster
laster64830633__laster
master84831343__master
oleaster837263oleaster
outmaster1147303outmaster
oyster94111703oy__ster
paster85734373__paster
paymaster1643873paymaster
piaster93012883_piaster
pilaster1038163pilaster
pinaster1037113pinaster
plaster93318693_plaster
poetaster1145673poetaster
raster64731443__raster
remaster10311473remaster
retaste72313133retaste_
retasted92412113retasted
retastes82212903retastes
roaster74116663_roaster
spymaster1642583spymaster
starter73817883_starter
stater64427563_sta_ter
tapster9299273__tapster
tarter64023563__tarter
taste55127233__taste_
tasted74123973__tasted
tasters74225643__tasters
tastes64126423__tastes
tastier711817093__tastier
tater54138613__ta_ter
tatter64024573__tatter
tauter64318023__tauter
teataster944563teataster
tester64227153__tester
toaster74414463_toaster
untasted92011573untasted
vaster94521023__vaster
waster95228943__waster
xyster16366803xy__ster
yatter94116213_y_atter
yeasted1138503_yeasted
yeastier1135393_yeastier
yester93417983_y_ester

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.423422437.4
2DLD Change Limit1461621087.53019410.6
3Display Results1081080.0333272.7
 (SQL Overall)1786911087.98622375.5
 
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.