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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

92 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
jokesters204444(None) 
jokester1934441jokester_
dopesters1237282dopesters
foresters12312532foresters
jesters144118192j__esters
jousters153210422jo_usters
molesters1198872molesters
arresters948193arresters
attesters935803attesters
bimesters1336343bimesters
boasters103915663bo_asters
bolsters103712453bo_lsters
boosters104013443bo_osters
coasters104317333co_asters
contesters12410183contesters
costers94128333co__sters
coveters132411083cove_ters
detesters10298303detesters
diesters92513603_diesters
digesters11257883digesters
doomsters1236173doomsters
dopester1137253dopester_
esters64627733___esters
festers104121393__festers
fomenters1437853fomenters
foreseers1237403foreseers
forester11313673forester_
fosters104220103fo__sters
gamesters1236733gamesters
hoisters113513483ho_isters
holsters113211943ho_lsters
honester1139713honester_
hoopsters1445693hoopsters
infesters12237713infesters
jester134319153j__ester_
jockettes2254383jockette_s
jointers15289323jo_inters
jokers175511193jok___ers
jolters143711993jo__lters
joneses1438963jones_e_s
joshers174111593jo__shers
jostlers15357683jo__stlers
jotters143413803jo__tters
jouster143311043jo_uster_
junketers2042933junke_ters
justers143815733j__usters
keesters12319593_keesters
keisters123212043__keisters
kelters113813753__kelters
keysters15326333__keysters
kiesters123310153_kiesters
lobsters10268743lo_bsters
lodestars1044413lodestars
mobsters12359063mo_bsters
modester1197483modester_
molester1099373molester_
monoesters1245993monoesters
monsters103314553mo_nsters
nesters74422793__nesters
oldsters996733_oldsters
oleasters936733_oleasters
ousters74122793_o_usters
oysters103411693_o_ysters
pesters93827093__pesters
pocketers17196493pocke_ters
polestars1157283polestars
pollsters1137173pollsters
polyesters1545233polyesters
posters93928013po__sters
presters103419003_presters
protesters12169383protesters
questers17168763_questers
resters74130403__resters
rimesters1137483rimesters
roadsters1035103roadsters
roasters83615933ro_asters
rocketers15186883rocke_ters
roisters83615553ro_isters
roosters83514663ro_osters
rosters73727543ro__sters
rousters84315683ro_usters
roysters113610533ro_ysters
semesters1139123semesters
skeeters12298963_skeeters
skelters12349373_skelters
songsters1046113songsters
testers74124543__testers
toasters83912723to_asters
westers105221963__westers
wresters112711733_wresters
zesters163517293__zesters
zosters163015413zo__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.436409841.7
2DLD Change Limit148641927.23620541.9
3Display Results92920.0462000.0
 (SQL Overall)178691927.71823152.5
 
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.