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

119 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
voyagers153281(None) 
voyager1433511voyager_
voyages1435701voyage_s
voyageurs164731voyageurs
dowagers1334892dowagers
foragers12349622foragers
homagers1486822homagers
onagers838102_onagers
socagers1196362socagers
voyage1335472voyage__
voyaged1533512voyage_d
voyageur154852voyageur
yagers105114532__yagers
agers65027853___agers
boaters93419233bo_aters
boogers104514633bo_ogers
borages103917163borage_s
boyars115611983boya__rs
buoyages1443803buoyage_s
cagers95624183__cagers
coalers94419333co_alers
coaters93525773co_aters
coaxers164311063co_axers
codgers115113923co_dgers
comakers16339163comakers
congers104223233co_ngers
cottagers12305373cottagers
cowages13310933cowage_s
damagers1237063damagers
dodgers105213823do_dgers
doggers104413433do_ggers
dosages92310803dosage_s
dotages92311793dotage_s
dowager1245803dowager_
eagers74523683__eagers
engagers10246543engagers
foamers123812103fo_amers
foggers124112013fo_ggers
forager114412553forager_
forages114217273forage_s
forayers14277273forayers
forgers115218183fo_rgers
foyers125413133foy__ers
gagers84021323__gagers
gorgers94813643go_rgers
gougers94911763go_ugers
hoaxers17327133ho_axers
hoggers124512483ho_ggers
homager13107853homager_
homages131011583homage_s
imagers10107753_imagers
jagers144415723__jagers
joggers164110693jo_ggers
kayakers1463613kayakers
laagers83411253_laagers
lagers74826143__lagers
loaders83413413lo_aders
loafers10349463lo_afers
loaners73913623lo_aners
locaters102710063locaters
lodgers95113833lo_dgers
loggers94616133lo_ggers
longers84819533lo_ngers
loungers9449003loungers
lovages1138033lovage_s
loyaler1035083loyaler_
managers112911003managers
moaners92813553mo_aners
mongers104217273mo_ngers
nonages8313843nonage_s
noyades1136563noyade_s
oaters65029783_o_aters
onager739663_onager_
oyers87620883_oy__ers
oysters103411683_oysters
pagers94423253__pagers
potages102416423potage_s
ravagers1235573ravagers
roamers93713453ro_amers
roarers73812733ro_arers
rogers74517913ro__gers
roysters113610523roysters
soakers114114953so_akers
soapers93715923so_apers
soarers74118093so_arers
socager10107703socager_
socages101012053socage_s
solacers10268893solacers
stagers84116673_stagers
swagers114211023_swagers
tanagers9259003tanagers
tongers84116013to_ngers
towages1139233towage_s
toyers95516333toy__ers
vealers103214293v_ealers
veligers1237023veligers
vergers114412623v_ergers
villagers13296133villagers
vintagers13123893vintagers
violaters1245953violaters
visages1138693visage_s
vitamers1334673vitamers
vocoders1434243vocoders
voguers11356683vo_guers
voicers12348993vo_icers
voiders11279823vo_iders
voltages1237253voltage_s
vomers115614943vo__mers
vomiters1337203vomiters
vorlages1236033vorlage_s
votaress1144223votaress
voters95017443vo__ters
vouchers16418623vouchers
vowers124317183vo__wers
voyaging1632553voyaging
voyeurs1332423voy_eurs
wagers105122203__wagers
yager95616753__yager_
youngers12336933youngers

Search took 7 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 Filter1786911461620.1701051123.5
2DLD Change Limit1461621196.36022981.4
3Display Results1191190.0462587.0
 (SQL Overall)1786911196.57627173.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.