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

123 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
scamsters133499(None) 
scamster1235311scamster_
seamsters1136331seamsters
casters94729902_ca_sters
hamsters13710422_hamsters
lamsters1099752_lamsters
scammers14339772scam_mers
scampers143611032scam_pers
scatters103612752sca_tters
scimiters1345122scimiters
seamster1037142seamster_
teamsters1135972teamsters
asters65631603__a_sters
basters94930313_ba_sters
blasters104116143bla_sters
boasters103915663boa_sters
cadasters1236833_cadasters
cambers134017443_cam_bers
campers134220293_cam_pers
canisters112310203_canisters
canters94827733_ca_nters
carters95327263_ca_rters
caster85232573_ca_ster_
castes85631863_ca_ste_s
castors94919443_ca_stors
caters85336503_ca__ters
causers94014793_caus_ers
clusters102912403_clusters
clysters13227843_clysters
coasters104317343_coasters
costers94128343_c_osters
dabsters1137053_dabsters
decameters15156593decameters
deemsters1285023deemsters
diameters1247603diameters
diasters92913183dia_sters
doomsters1236173doomsters
dragsters1134333dragsters
easters75125683_ea_sters
feasters11511563fea_sters
gagsters10317083_gagsters
gamesters1236743_gamesters
gasters85624303_ga_sters
hamster12810423_hamster_
lamisters1157123_lamisters
lamster9109913_lamster_
lasters75627693_la_sters
masters94628923_ma_sters
octameters1444833octameters
pasters94531733_pa_sters
piasters102912813pia_sters
plaisters1137813plaisters
plasters103518133pla_sters
rasters74629023_ra_sters
remasters11310583remasters
roadsters1035103roadsters
roasters83615933roa_sters
salters73622253s_a_lters
saluters8319863s_aluters
samites93118713s_amite_s
samplers12299403s_amplers
saunters82911753s_aunters
scalers93817263sca__lers
scalpers123710863sca_lpers
scammer133611973scam_mer_
scamper134613163scam_per_
scamperers1643473scamperers
scampies1439333scampie_s
scanners10379703sca_nners
scanter94215183sca_nter_
scarers94618513sca__rers
scarfers13408463sca_rfers
scarpers124712513sca_rpers
scatter93815173sca_tter_
scaupers12378173sca_upers
scepters1237803sc_epters
schmeers1574833schm_eers
schussers1442553schussers
scimetars1344013scimetars
scimitars1343173scimitars
scimiter1236143scimiter_
scooters103511033sc_ooters
scoters93313813sc__oters
scouters103411323sc_outers
scramblers16183543scramblers
scripters13116683scripters
scummers14277783scum_mers
scutters103311023sc_utters
seamers94719433seam__ers
seamstress1242283seamstress
seaters74028943sea__ters
seawaters1235713seawaters
semesters1139123semesters
shammers153710843sham_mers
shatters113313913sha_tters
shysters14106463s_hysters
sisters73721593s__isters
skaters113512963ska__ters
slammers123511223slam_mers
slashers113313613sla_shers
slaters73123733sla__ters
smashers13339593sma_shers
smatters104011713sma_tters
smiters93414363s__miters
songsters1046113songsters
spammers14378693spam_mers
spatters103914703spa_tters
spinsters1136613spinsters
spymasters1742803spymasters
stammers123611523stam_mers
stampers124211603stam_pers
starters83714783sta_rters
staters73922343sta__ters
sumpters1238023s_umpters
swampers15317473swam_pers
swashers14389533swa_shers
swatters113911793swa_tters
tapsters10318803_tapsters
tasters74225643_ta_sters
teamster1036293teamster_
toasters83912723toa_sters
waisters113811523_waisters
wasters104026593_wa_sters

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.440406115.9
2DLD Change Limit1486411237.14020818.1
3Display Results1231230.0631952.4
 (SQL Overall)1786911237.64323379.7
 
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.