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

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
festers10412139(None) 
esters64627731_esters
feasters11511561feasters
fester94723511fester_
fetters103517901fetters
fosters104220091fosters
jesters144118191jesters
nesters74422781nesters
pesters93827091pesters
resters74130401resters
testers74124541testers
westers105221961westers
zesters163517291zesters
asters65631602_asters
basters94930302basters
beaters94925032beaters
belters93819412belters
bestirs9311132bestirs
betters94422092betters
bisters93922602bisters
busters94724122busters
casters94729892casters
centers94420592centers
costers94128302costers
deters74724682de_ters
diesters92513592diesters
dusters84918352dusters
easters75125682easters
eaters65535942_eaters
enters64425642_enters
eskers105312222_eskers
ester54727712_ester_
falters103916472falters
fastens105511752fastens
faster94625772faster_
fearers104815272fearers
feaster10812982feaster_
feater95224052feater_
feathers143513242feathers
feeders113712862feeders
feelers103814742feelers
fellers104117542fellers
fencers123810622fencers
fenders113717262fenders
fesses94820252fesse_s
festered122512102festered
fests85828042fest__s
fetes85630142fe_te_s
fetors91014472fe_tors
fetter94120382fetter_
fevers125414892fe_vers
fibsters13126402fibsters
filters103816542filters
fishers134714722fishers
fitters104517742fitters
fleshers14339442fleshers
flusters113811492flusters
fluters103713672fluters
footers104618332footers
foresters12312532foresters
foster94322222foster_
fraters103517202fraters
fretters113410302fretters
fussers104210812fussers
gasters85624282gasters
gestes75721392geste_s
getters84216092getters
heaters104225212heaters
hefters134312002hefters
heisters113413132heisters
infesters12237702infesters
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
tasters74225642tasters
teeters74018302teeters
tenters73921102tenters
testees74215912testees
tester64227152tester_
testes65125822teste_s
tetters74320472tetters
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.1431249587.4
2DLD Change Limit1076711413.84328017.4
3Display Results1411410.0463065.2
 (SQL Overall)1786911414.03244318.2
 
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.