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

141 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
teamsters113597(None) 
seamsters1136331seamsters
teamster1036291teamster_
deemsters1285022deemsters
easters75125682_ea_sters
feasters11511562fea_sters
hamsters13710422_hamsters
lamsters1099752_lamsters
remasters11310582remasters
scamsters1334992scamsters
seamster1037142seamster_
tapsters10318802t_apsters
tasters74225642t_a_sters
teamakers1544872teamakers
teasers75317242tea_s_ers
teatasters1043882teatasters
tempters12257292te_mpters
testers74124542te__sters
toasters83912722toa_sters
asters65631603__a_sters
basters94930313_ba_sters
beaters94925043bea__ters
blasters104116143bla_sters
boasters103915663boa_sters
casters94729903_ca_sters
coasters104317343coa_sters
dabsters1137053_dabsters
decameters15156593decameters
deemster1175713deemster_
dekameters17164863dekameters
delusters1035983delusters
demisters1249203demisters
dempsters1435273dempsters
detesters10298303detesters
diameters1247603diameters
diasters92913183dia_sters
doomsters1236173doomsters
dragsters1134333dragsters
easter65027983_ea_ster_
eastern74412533_ea_stern
eaters65535953_ea__ters
emoters94712873_e_moters
esters64627733_e__sters
feaster10812983fea_ster_
festers104121393fe__sters
gagsters10317083_gagsters
gamesters1236743_gamesters
gasters85624303_ga_sters
geometers1238193geometers
hamster12810423_hamster_
headmasters17174303headmasters
heaters104225223hea__ters
heisters113413133he_isters
hexameters2244453hexameters
jesters144118193je__sters
keesters12319593ke_esters
keisters123212043ke_isters
keysters15326333ke_ysters
lamisters1157123_lamisters
lamster9109913_lamster_
lasters75627693_la_sters
leasers74717843lea_s_ers
leisters83312823le_isters
masters94628923_ma_sters
meisters103313843me_isters
nesters74422793ne__sters
oleasters936733olea_sters
pasters94531733_pa_sters
pensters103012123pe_nsters
pesters93827093pe__sters
piasters102912813pia_sters
plaisters1137813plaisters
plasters103518133pla_sters
rasters74629023_ra_sters
realters83614043rea_lters
reamers94221083ream__ers
registers1038893registers
remaster10311473remaster_
resisters9310453resisters
resters74130403re__sters
roadsters1035103roadsters
roasters83615933roa_sters
scamster1235313scamster_
seamers94719433seam__ers
seamstress1242283seamstress
seaters74028943sea__ters
seawaters1235713seawaters
semesters1139123semesters
steamers103410873steam__ers
tamers84224033t_am__ers
tampers113516743t_am_pers
tapster9299273t_apster_
tarsiers8298533t_arsiers
taster64930573t_a_ster_
tastes64126423t_a_ste_s
taters64932203t_a__ters
tatters74520483t_a_tters
taunters8259273t_aunters
teachers133212393tea_chers
teamaker1445113teamaker_
teammates1345673teammate_s
tearers75218233tea__rers
teaselers9165853teaselers
teasels74311313tea_s_els
teaser65421523tea_s_er_
teases65426273tea_s_e_s
teataster944563teataster_
teemers95012903teem__ers
teeters74018303te__eters
telemeters1246683telemeters
tempers113513013te_m_pers
tempter11358213te_mpter_
tenters73921113te__nters
termers95414503term__ers
termites10313693termite_s
testees74215913te__stees
tester64227153te__ster_
testes65125823te__ste_s
tetrameters1354623tetrameters
tetters74320473te__tters
theaters114211903thea__ters
thirsters1235233thirsters
thrusters1245333thrusters
tipsters10278523t_ipsters
toaster74414463toa_ster_
trampers123210393tram_pers
tramplers13305883tramplers
transfers1238053transfers
trashers113013643tra_shers
treaters83615853trea__ters
trimesters1245423trimesters
trimeters1139213trimeters
trusters83112263t_rusters
trysters11298373t_rysters
twisters11268173t_wisters
waisters113811523_waisters
wasters104026593_wa_sters
webmasters1742913webmasters
websters1335803we_bsters
westers105221963we__sters
zesters163517293ze__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.420425454.8
2DLD Change Limit1486411417.06321045.0
3Display Results1411410.0632238.1
 (SQL Overall)1786911417.54623680.2
 
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.