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
voyageurs164741voyageurs
dowagers1334892dowagers
foragers12349632foragers
homagers1486832homagers
onagers838102_onagers
socagers1196362socagers
voyage1335472voyage__
voyaged1533512voyage_d
voyageur154852voyageur
yagers105114532__yagers
agers65027853___agers
boaters93419243bo_aters
boogers104514633bo_ogers
borages103917163borage_s
boyars115611983boya__rs
buoyages1443803buoyage_s
cagers95624193__cagers
coalers94419353co_alers
coaters93525793co_aters
coaxers164311083co_axers
codgers115113933co_dgers
comakers16339173comakers
congers104223233co_ngers
cottagers12305383cottagers
cowages13310943cowage_s
damagers1237073damagers
dodgers105213823do_dgers
doggers104413433do_ggers
dosages92310803dosage_s
dotages92311793dotage_s
dowager1245803dowager_
eagers74523683__eagers
engagers10246553engagers
foamers123812103fo_amers
foggers124112013fo_ggers
forager114412563forager_
forages114217283forage_s
forayers14277273forayers
forgers115218183fo_rgers
foyers125413133foy__ers
gagers84021333__gagers
gorgers94813643go_rgers
gougers94911763go_ugers
hoaxers17327133ho_axers
hoggers124512483ho_ggers
homager13107853homager_
homages131011593homage_s
imagers10107763_imagers
jagers144415723__jagers
joggers164110693jo_ggers
kayakers1463613kayakers
laagers83411253_laagers
lagers74826143__lagers
loaders83413433lo_aders
loafers10349463lo_afers
loaners73913623lo_aners
locaters102710073locaters
lodgers95113833lo_dgers
loggers94616133lo_ggers
longers84819543lo_ngers
loungers9449003loungers
lovages1138033lovage_s
loyaler1035083loyaler_
managers112911003managers
moaners92813553mo_aners
mongers104217273mo_ngers
nonages8313843nonage_s
noyades1136563noyade_s
oaters65029793_o_aters
onager739663_onager_
oyers87620883_oy__ers
oysters103411693_oysters
pagers94423253__pagers
potages102416423potage_s
ravagers1235583ravagers
roamers93713463ro_amers
roarers73812743ro_arers
rogers74517913ro__gers
roysters113610533roysters
soakers114114953so_akers
soapers93715923so_apers
soarers74118093so_arers
socager10107703socager_
socages101012053socage_s
solacers10268893solacers
stagers84116673_stagers
swagers114211023_swagers
tanagers9259003tanagers
tongers84116013to_ngers
towages1139233towage_s
toyers95516333toy__ers
vealers103214293v_ealers
veligers1237023veligers
vergers114412633v_ergers
villagers13296153villagers
vintagers13123903vintagers
violaters1245963violaters
visages1138693visage_s
vitamers1334683vitamers
vocoders1434243vocoders
voguers11356693vo_guers
voicers12348993vo_icers
voiders11279823vo_iders
voltages1237253voltage_s
vomers115614943vo__mers
vomiters1337203vomiters
vorlages1236033vorlage_s
votaress1144223votaress
voters95017443vo__ters
vouchers16418623vouchers
vowers124317183vo__wers
voyaging1632563voyaging
voyeurs1332423voy_eurs
wagers105122213__wagers
yager95616753__yager_
youngers12336933youngers

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 Filter1786911461620.843211970.3
2DLD Change Limit1461621198.23617746.7
3Display Results1191190.0462587.0
 (SQL Overall)1786911199.12519582.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.