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 “resters” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

199 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
resters7413040(None) 
esters64627731_esters
festers104121391festers
jesters144118191jesters
nesters74422781nesters
pesters93827091pesters
presters103419001presters
rasters74629021rasters
renters74224811renters
rester63832431rester_
rosters73727531rosters
testers74124541testers
westers105221961westers
wresters112711731wresters
zesters163517291zesters
arresters948192arresters
asters65631602_asters
basters94930302basters
beaters94925032beaters
belters93819412belters
bestirs9311132bestirs
betters94422092betters
bisters93922602bisters
busters94724122busters
casters94729892casters
centers94420592centers
costers94128302costers
deters74724682de_ters
diesters92513592diesters
dressers9359862dressers
dusters84918352dusters
easters75125682easters
eaters65535942_eaters
enters64425642_enters
erecters102611612erecters
eskers105312222_eskers
ester54727712_ester_
feasters11511562feasters
fester94723512fester_
fetters103517902fetters
foresters12312532foresters
fosters104220092fosters
fretters113410302fretters
gasters85624282gasters
gestes75721392geste_s
getters84216092getters
greeters92610112greeters
gristers94013402gristers
heaters104225212heaters
hefters134312002hefters
heisters113413132heisters
jester134319152jester_
justers143815722justers
keesters12319592keesters
keisters123212042keisters
kelters113813752kelters
keysters15326332keysters
kiesters123310142kiesters
lasters75627692lasters
leisters83312822leisters
letters73819852letters
listers74026522listers
lusters73921432lusters
masters94628922masters
meeters94714542meeters
meisters103313842meisters
melters93918312melters
mestees94617752mestees
meters85625832me_ters
misters93927502misters
musters94522492musters
nester64124182nester_
nestlers8359222nestlers
nestors73614952nestors
netters73618582netters
neuters74212262neuters
ousters74122772ousters
oysters103411682oysters
pasters94531732pasters
pelters93720312pelters
pensters103012122pensters
pester84827592pester_
peters86624592pe_ters
petters93722362petters
pewters124113352pewters
posters93927992posters
pressers103215022pressers
prester93519622prester_
questers17168762questers
rafters103715632rafters
ranters73323642ranters
rasers64526782ras_ers
rashers104020902rashers
raspers94415912raspers
raster64731442raster_
raters63936572r_aters
ratters74422472ratters
readers83823762readers
realters83614042realters
reamers94221082reamers
reapers93520452reapers
rearers74323562rearers
reavers108320742reavers
rebaters103413912rebaters
reciters102613112reciters
rectors93520512rectors
redders93615342redders
reefers103312592reefers
reekers113613142reekers
reelers73520272reelers
reenters82915302reenters
refers93921082re_fers
refuters11449602refuters
registers1038882registers
reinters82614772reinters
reivers105117082reivers
relaters83218142relaters
reliers75519212reliers
remasters11310582remasters
renders83821672renders
renter64527412renter_
rentes65431192rente_s
rentiers83311762rentiers
rescuers1037362rescuers
reseeds84012332reseeds
reseeks11348622reseeks
resees63827482res_ees
resets65427612res_ets
resetters9129462resetters
resews94814172res_ews
reshes94124362reshe_s
residers93311882residers
resisters9310452resisters
resites74027792resite_s
resorters939682resorters
restart7320032restart
restarts8310872restarts
rested74430782reste_d
restless82713162restless
restore75822972restore
restorers95110112restorers
restores85222982restores
restress82511772restress
rests54935872rest__s
resumers1038082resumers
retears72814922re_tears
retems83914572re_tems
reutters8138562reutters
revers94529632re_vers
rimesters1137472rimesters
rioters73615502rioters
risers64624782ris_ers
riskers114011992riskers
ritters74020612ritters
roasters83615912roasters
roisters83615542roisters
roosters83514652roosters
rooters74522932rooters
roster64329082roster_
rotters74421392rotters
rousters84315652rousters
routers74822852routers
roysters113610522roysters
rushers103816102rushers
rustlers8339852rustlers
seaters74028932seaters
sestets7911472sestets
setters73822062setters
sisters73721572sisters
tasters74225642tasters
teeters74018302teeters
tenters73921102tenters
testees74215912testees
tester64227152tester_
testes65125822teste_s
tetters74320472tetters
treaters83615822treaters
trusters83112242trusters
trysters11298362trysters
ulsters72711982ulsters
ureters7311822ure_ters
venters103717722venters
vespers1239032vespers
vestees103513162vestees
vetters104016312vetters
wasters104026592wasters
websters1335802websters
welters103516062welters
wester94222892wester_
western102911092western
westerns11328962westerns
wetters103817752wetters
wrester102812412wrester_
wrestlers12306102wrestlers
xysters17307162xysters
yester93417982yester_
yestern10338632yestern
zester153617792zester_
zosters163015402zosters

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 Filter1786911076710.1561145455.1
2DLD Change Limit1076711997.01615346.5
3Display Results1991990.1561275.6
 (SQL Overall)1786911997.32824384.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.