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

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

88 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
bonesetters135263(None) 
bonesetter1253181bonesetter_
besetters11136642b__esetters
begetters12135043b__egetters
besetter10137983b__esetter_
bonesets1036843bonese_t__s
consenters12410843con_senters
honeyeaters1752903honeyeaters
insetters9187133_in_setters
pacesetters1552023pacesetters
pinsetters1244103pin_setters
resetters9129463__resetters
typesetters1651693typesetters
anisettes946674_anisette_s
banisters11189474banis__ters
bannerettes1352304bannerette_s
banqueters2143144banque_ters
banquettes2184374banquette_s
bedwetters1642274b_edwetters
beefeaters1553234b_eefeaters
beetlers1037404b__e_etlers
begetter11136314b__egetter_
benefiters1543344bene_fiters
bespatters1442784b__espatters
betatters1134964b__etatters
betters94422094b____etters
bimesters1336344bimes__ters
boasters103915664bo_as__ters
bolometers1447384bolome_ters
bolsterers1244684bo_lsterers
bolsters103712454bo_ls__ters
boneset9316434bonese_t___
booksellers1751964booksellers
boosters104013444bo_os__ters
boycotters1741914bo_ycotters
concenters14410584con_centers
connecters1448014con_necters
consenter11312494con_senter_
conservers1547684con_servers
consulters1297214con_sulters
contesters12410184con_testers
converters1539634con_verters
deserters10129984__deserters
dopesters1237284dopes__ters
enfetters1244464_en_fetters
filmsetters1651424filmsetters
foreseers1237404forese__ers
foresters12312534fores__ters
forgetters1444164fo_rgetters
fossettes1245084fo_ssette_s
honester1139714hones__ter_
honesties1249914hones_tie_s
honeyeater1653604honeyeater_
inserters92210284_in_serters
insetter8218594_in_setter_
jokesters2044444jokes__ters
molesters1198874moles__ters
monoesters1245994mon_oesters
monometers1449364monome_ters
monsters103314554mon_s__ters
nesters74422794__nes__ters
nestlers8359234__nes_tlers
netters73618584__n__etters
newsletters14141694__newsletters
noisettes946534no_isette_s
nonskaters1444484non_skaters
novelettes1343874novelette_s
omelettes1144744_omelette_s
overeaters1348634_overeaters
pacesetter1452394pacesetter_
photosetters1773924photosetters
pinsetter1145014pin_setter_
poussettes1243534poussette_s
presenters1239864_presenters
reletters9138784__reletters
resetter81511834__resetter_
rosettes8310344ro__sette_s
setters73822064____setters
songsters1046114songs__ters
sonneteers1042934son_neteers
stonecutters1451114stonecutters
tonettes839204ton__ette_s
tonometers1248114tonome_ters
towelettes1342744towelette_s
trendsetters1351074trendsetters
typesetter1551824typesetter_
unfetters1244364_un_fetters
upsetters1143654__upsetters

Search took 10 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 Filter1786911488190.423422437.4
2DLD Change Limit148819888.61017284.4
3Display Results88880.0461913.0
 (SQL Overall)178691889.07919681.8
 
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.