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

190 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
margined123774(None) 
bargained1344952bargained
imagined1254782ima_gined
jargoned1735232jargoned
machined1637302machined
maligned1285772maligned
margented1346812margented
margin94016842margin__
marginal1137602marginal
marginated14187342marginated
margins103815192margin_s
marine84230402mar_ine_
mariner93315992mar_iner
marines93928012mar_ines
marline93320952marline_
marlines103818712marlines
marooned1138562marooned
married104715302marri_ed
martinet10319642martinet
sardined10268662sardined
affined1436413_affined
aligned9128553_aligned
alined75221403_a_lined
argled85314553_arg_led
argued84311173_arg_ued
ariled75620323_ar_iled
arointed939003_arointed
arrived11127353_arrived
arsine64021043_arsine_
arsines73518813_arsines
bargainer1244563bargainer
barged105822643barg__ed
barging114018483bargin_g
barned95623583bar__ned
basined10310003ba_sined
brained103816103_brained
brined95118413_br_ined
cabined1239993ca_bined
calcined1338743calcined
carbine112918643carbine_
carbines123617533carbines
careened1139193careened
caried94528693car_i_ed
carline93923613carline_
carlines103521643carlines
carmine112918483carmine_
carmines123617863carmines
carried103717153carri_ed
cartoned111312833cartoned
chagrined1643833chagrined
darkened1435943darkened
darned85018483dar__ned
drained93713253_drained
earned74818333ear__ned
earringed1144453earringed
engined9119893_engined
ermined10410603_ermined
gained84617463ga__ined
gardened1137003gardened
garganey1344883garganey
gargled104210673garg_led
grained93814273_grained
groined92710813_groined
hardened1338613hardened
harkened1637483harkened
harmine122816193harmine_
harmines132715143harmines
harried113815533harri_ed
imagine1037883ima_gine_
imaginer1144303ima_giner
imagines1137463ima_gines
jargonel1643683jargonel
larine63927043lar_ine_
machine14313493machine_
machines15312893machines
maddened1334893maddened
magicked1842963ma_gicked
magnet9320663ma_g_net
mailed95326753ma__iled
maimed114812663ma__imed
mainlined1254353mainlined
maligner11115333maligner
maline84529083ma_line_
malines93625603ma_lines
maned86634103ma___ned
mangier104114063mangi_er
manginess122010413manginess
mangled113615263mang_led
mangonel1185763mangonel
mankind1437773mankin_d
manned94418643ma__nned
marauded1244333marauded
marbled123212113mar_bled
marched153813403mar_ched
margarine1247713margarine_
margarines1347203margarines
marge85328333marg__e_
margent10316693margen_t
margents11410133margents
marges94525713marg__es
marginals1246003marginals
marginate12179603marginate
marginates13168743marginates
margining1337603margining
marigold1244093marigold
marina84623413mar_in_a
marinade11259383mar_inade
marinaded13276533mar_inaded
marinas93519383mar_inas
marinated122513173mar_inated
mariners103113863mar_iners
marked133921623mar__ked
marketed1537323marketed
marking144020133markin_g
markings153410243markings
marled95523163mar__led
marlier92614773marli_er
marlin84220903marlin__
marling103322763marlin_g
marlings113713493marlings
marlins93420473marlin_s
marlite92917073marlite_
marlites103415263marlites
marmite112413993marmite_
marmites122212793marmites
marred95421043mar__red
marrieds11288073marri_eds
marrier93817523marri_er
marries93825283marri_es
marring103319553marrin_g
marrowed1445973marrowed
marted94425213mar__ted
martin84122523martin__
martinets1138883martinets
marting103325013martin_g
martini93613873martin_i
martinis103311613martinis
martins93322063martin_s
martyred1434283martyred
marveled1436433marveled
masoned1039803ma_soned
matinee92415613ma_tinee
merged104214953merg__ed
merging112711763mergin_g
merited10313853mer_ited
mined85333353m___ined
moraine9314573moraine_
moraines10314363moraines
morticed1377163morticed
mortised1178743mortised
murine84220023mur_ine_
murines93718223mur_ines
murrine9411483murrine_
mutined103311353m_utined
nardine82712573nardine_
nargile847653nargile_
nargileh1272433nargileh
nargiles976793nargiles
narine63422553nar_ine_
pained95622853pa__ined
paragoned1357063paragoned
pardine103616723pardine_
pardoned12189333pardoned
parged104922043parg__ed
pargeted1238683pargeted
parging113318603pargin_g
pargings123410163pargings
parried103615723parri_ed
partied103516553parti_ed
patined105114783pa_tined
rained75024603__rained
ravined115411823ra_vined
reined74425523__reined
ruined74813323__ruined
sained75424243sa__ined
sardine83317393sardine_
sardines92815563sardines
shrined114112413shr_ined
smartened1244263smartened
sprained1138433sprained
strained9412253strained
targeted1037483targeted
tarried83914133tarri_ed
trained84117203_trained
trined74920713_tr_ined
varied104817863var_i_ed
waggoned1443253waggoned
wagoned1256223wa_goned
warned104018913war__ned
yarned105514023yar__ned

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621907.53319402.9
3Display Results1901900.0603166.7
 (SQL Overall)1786911908.01622291.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.