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

160 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
testers7412454(None) 
esters64627731_esters
festers104121391festers
jesters144118191jesters
nesters74422781nesters
pesters93827091pesters
resters74130401resters
tasters74225641tasters
teeters74018301teeters
tenters73921101tenters
testees74215911testees
tester64227151tester_
testes65125821teste_s
tetters74320471tetters
westers105221961westers
zesters163517291zesters
asters65631602_asters
attesters935802attesters
basters94930302basters
beaters94925032beaters
belters93819412belters
bestirs9311132bestirs
betters94422092betters
bisters93922602bisters
busters94724122busters
casters94729892casters
centers94420592centers
costers94128302costers
deters74724682de_ters
detesters10298302detesters
diesters92513592diesters
dusters84918352dusters
easters75125682easters
eaters65535942_eaters
enters64425642_enters
eskers105312222_eskers
ester54727712_ester_
feasters11511562feasters
fester94723512fester_
fetters103517902fetters
fosters104220092fosters
gasters85624282gasters
gestes75721392geste_s
getters84216092getters
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
presters103419002presters
questers17168762questers
rasters74629022rasters
renters74224812renters
rester63832432rester_
rosters73727532rosters
seaters74028932seaters
sestets7911472sestets
setters73822062setters
sisters73721572sisters
tapsters10318802tapsters
taster64930572taster_
tastes64126422taste_s
taters64932192t_aters
tatters74520482tatters
teamsters1135972teamsters
tearers75218232tearers
teasers75317242teasers
tedders94010232tedders
teemers95012902teemers
teeners74415452teeners
teeter65420312teeter_
teethers11328712teethers
telfers10299072telfers
tellers73717582tellers
tempers113513012tempers
tempters12257292tempters
tenders83719722tenders
tenners74014922tenners
tenter64623932tenter_
termers95414502termers
tessera736332tessera
tested74421522teste_d
testee64323302teste_e
testier74015642testier_
testis64916712test_is
testons7313552testons
tests56530192test__s
tethers103815312tethers
tetter64322452tetter_
theaters114211892theaters
tilters73315932tilters
tinters74221102tinters
tipsters10278502tipsters
titers64526402t_iters
titters74219612titters
toasters83912702toasters
tooters73818772tooters
tossers74713492tossers
toters65026362t_oters
totters74618732totters
touters74018332touters
treaters83615822treaters
trusters83112242trusters
trysters11298362trysters
tufters10298342tufters
tuskers113710032tuskers
tussers74313562tussers
tweeters11287142tweeters
twisters11268172twisters
ulsters72711982ulsters
venters103717722venters
vespers1239032vespers
vestees103513162vestees
vetters104016312vetters
wasters104026592wasters
websters1335802websters
welters103516062welters
wester94222892wester_
western102911092western
westerns11328962westerns
wetters103817752wetters
wresters112711732wresters
xysters17307162xysters
yester93417982yester_
yestern10338632yestern
zester153617792zester_
zosters163015402zosters

Search took 5 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.1401276364.3
2DLD Change Limit1076711603.94027327.7
3Display Results1601600.0463478.3
 (SQL Overall)1786911604.12643308.5
 
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.