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

177 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
seamster103714(None) 
scamster1235301scamster
seamsters1136331seamsters
teamster1036291teamster
deemster1175712deemster
easter65027982_ea_ster
feaster10812982fea_ster
hamster12810422_hamster
lamster9109912_lamster
remaster10311472remaster
scamsters1334992scamsters
seamer84223612seam__er
seamier93114632seam_ier
seater64534162sea__ter
seawater1136602seawater
semester1038902semester
teamsters1135972teamsters
aster55434893__a_ster
baster85333593_ba_ster
beamier113411943beam_ier
beater84729393bea__ter
blaster94017303bla_ster
boaster94616433boa_ster
caster85232573_ca_ster
chaster124718503cha_ster
coaster94219043coa_ster
dabster1036703_dabster
decameter14137363decameter
deemsters1285023deemsters
dekameter16135103dekameter
deluster936903deluster
demasted1238763demasted
demister11310223demister
dempster1355773dempster
detester9239683detester
diameter1148063diameter
diaster82813313dia_ster
doomster1135843doomster
dragster1034633dragster
easier64218463_ea_sier
eastern74412533_ea_stern
easters75125683_ea_sters
eater54639843_ea__ter
emoter85415193_e_moter
ester54727713_e__ster
faster94625773_fa_ster
feasted11310843fea_sted
feasters11511563fea_sters
feater95224053fea__ter
fester94723513fe__ster
gagster9317633_gagster
gamester1137323_gamester
gaster75027353_ga_ster
geometer1138423geometer
hamsters13710423_hamsters
headmaster16204643headmaster
heater94828303hea__ter
heister103613623he_ister
hexameter2144853hexameter
jester134319153je__ster
keester11319913ke_ester
keister113011573ke_ister
keyster14256153ke_yster
lamister1037653_lamister
lamsters1099753_lamsters
laster64830633_la_ster
leaser65322673lea_s_er
leister73212753le_ister
master84831343_ma_ster
meister93114163me_ister
neater64424313nea__ter
nester64124183ne__ster
oleaster837263olea_ster
paster85734373_pa_ster
pearter9412743pea_rter
penster92811953pe_nster
pester84827593pe__ster
piaster93012883pia_ster
plaister1068013plaister
plaster93318693pla_ster
raster64731443_ra_ster
realter73716313rea_lter
reamer84325213ream__er
register939553register
remasters11310583remasters
remoter94815973re_moter
resister8311653resister
rester63832433re__ster
roadster935463roadster
roaster74116663roa_ster
salter64325083s_a_lter
saluter73512453s_aluter
samite83020603s_amite_
samites93118713s_amites
sampler113212013s_ampler
sassier73413233s_assier
saunter72913453s_aunter
scammer133611973scam_mer
scamper134613163scam_per
scanter94215183sca_nter
scatter93815173sca_tter
scimiter1236143scimiter
seafarer1144843seafarer
sealer63928963sea__ler
seamed94823883seam__ed
seamen84518563seam__en
seamers94719433seam__ers
seams75731663seams___
seamstress1242283seamstress
searcher13209103searcher
searer65432023sea__rer
seasoner857693seasoner
seated75131063sea__ted
seaters74028943sea__ters
seatmate1048573seatmate_
seatmates1157823seatmates
seawaters1235713seawaters
secreter1038513secreter
sedater83713633se_dater
seemer84418043seem__er
seemlier1035193seemlier
seiser65318343se_is_er
semesters1139123semesters
sequester1844443sequester
sestet6826203se__stet
setter64023723se__tter
shammer144613143sham_mer
shatter103615703sha_tter
shyster13116563s_hyster
sinister838583sinister
sister64421583s__ister
skater105015493ska__ter
slammer113913033slam_mer
slasher104515333sla_sher
slater64429183sla__ter
slimsier1085213slimsier
smarter94113133sma_rter
smasher123911023sma_sher
smatter93613333sma_tter
smiter83616413s__miter
songster935793songster
spammer133410433spam_mer
sparser94311483spars_er
spatter94016523spa_tter
speedster1252733speedster
spinster1036683spinster
spymaster1642583spymaster
stammer116013343stam_mer
stamper113714403stam_per
starter73817883sta_rter
stater64427563sta__ter
steamer93313093steam__er
steamier1048303steam_ier
sumpter1138873s_umpter
swamper14349313swam_per
swampier1544593swampier
swasher134011513swa_sher
swatter104113323swa_tter
sweater103712723swea__ter
tapster9299273_tapster
taster64930573_ta_ster
teamaker1445113teamaker
teaser65421523tea_s_er
teataster944563teataster
tempter11358213te_mpter
tester64227153te__ster
toaster74414463toa_ster
vaster94521023_va_ster
waister103812383_waister
waster95228943_wa_ster
webmaster1643003webmaster
webster1236093we_bster
wester94222893we__ster
yeasted1138503yea_sted
yeastier1135393yea_stier
yester93417983ye__ster
zester153617793ze__ster

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.406440125.6
2DLD Change Limit1461621777.11020557.2
3Display Results1771770.0602950.0
 (SQL Overall)1786911777.57623586.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.