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

139 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
rimesters113748(None) 
bimesters1336341bimesters
rimester1037811rimester_
trimesters1245411trimesters
bimester1236162bimester_
diesters92513602di_esters
digesters11257882digesters
dimeters11411092dime_ters
gamesters1236732gamesters
kiesters123310152ki_esters
remasters11310582remasters
resters74130402r__esters
rhymesters1842602rhymesters
riveters11228162rive_ters
semesters1139122semesters
trimester1145822trimester_
trimeters1139212trime_ters
ammeters1237693amme_ters
arresters948193arresters
attesters935803attesters
biometers1339173biome_ters
bisters93922613bi__sters
cementers1338313cementers
deemsters1285023deemsters
demisters1249203demisters
dempsters1435273dempsters
detesters10298303detesters
diameters1247603diame_ters
diasters92913183di_asters
diester83013683di_ester_
dieters83216433di_e_ters
digester10258433digester_
digestors11257273digestors
dimeter10411893dime_ter_
disasters1039153disasters
diverters13227873diverters
dopesters1237283dopesters
dumpsters1453743dumpsters
esters64627733___esters
festers104121393__festers
fibsters13126413fi_bsters
figeaters1345753figeaters
filisters1237003filisters
fomenters1437853fomenters
foresters12312533foresters
gamester1137323gamester_
gristers94013403gri__sters
hamsters13710423ham_sters
hipsters13268793hi_psters
imposters13347343_imposters
imputers1235823_imputers
infesters12237713infesters
jesters144118193__jesters
jokesters2044443jokesters
keesters12319593_keesters
kiester11329973ki_ester_
lamenters1137683lamenters
lamisters1157123lamisters
lamsters1099753lam_sters
limewaters1543523limewaters
limiters10249333lim_iters
listers74026533li__sters
masters94628923__masters
meeters94714543__meeters
meisters103313843__meisters
melters93918313__melters
mestees94617753__mestees
meters85625833__me_ters
mimeses1139073mimes_e_s
ministers1139623ministers
minsters103813923mi_nsters
misenters1139533misenters
misters93927513__misters
molesters1198873molesters
musters94522513__musters
nesters74422793__nesters
orienters937613ori_enters
orometers11310423orome_ters
oximeters1855143oxime_ters
perimeters1448603perime_ters
pesters93827093__pesters
piasters102912813pi_asters
pilasters1138223pilasters
pinasters1136823pinasters
pipestems1542833pipestems
presters103419003_presters
priestess1145293pri_estess
protesters12169383protesters
questers17168763_questers
rasters74629023r__asters
reenters82915303r_eenters
registers1038893registers
reheaters122010273reheaters
rejecters18257543rejecters
reletters9138783reletters
remaster10311473remaster_
remembers1544493remembers
remitters11328403remitters
renters74224813r__enters
repeaters112811993repeaters
repenters112511553repenters
requesters1944323requesters
resetters9129463resetters
resisters9310453resisters
rester63832433r__ester_
reverters122710433reverters
rhymester1742393rhymester_
rievers104311453ri_e_vers
righters122610713ri_ghters
rimers84522553rim___ers
rimmers113812883rim__mers
ringmasters14132803ringmasters
rinsers73815743ri_ns_ers
rioters73615513ri__oters
ripeners1036833ripe_ners
ripostes10239083riposte_s
risers64624783ri__s_ers
riskers114011993ri__skers
ritters74020623ri__tters
riveter10208753rive_ter_
roadsters1035103roadsters
roasters83615933r_oasters
roisters83615553r_oisters
roosters83514663r_oosters
rosters73727543r__osters
rousters84315683r_ousters
roysters113610533r_oysters
semester1038903semester_
sidesteps1243623sidesteps
sisters73721593si__sters
smelters103310513_smelters
testers74124543__testers
timesavers1552163timesavers
tipsters10278513ti_psters
tricksters16264763tricksters
trimeter10310083trime_ter_
westers105221963__westers
wresters112711733_wresters
zesters163517293__zesters

Search took 9 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.410435831.7
2DLD Change Limit1486411397.75019179.5
3Display Results1391390.0602316.7
 (SQL Overall)1786911398.22021738.6
 
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.