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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

134 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
marine8423040(None) 
larine63927041larine
maline84529081maline
marina84623411marina
mariner93315991mariner
marines93928011marines
marline93320951marline
murine84220021murine
narine63422551narine
acarine9316002acarine
aline57243152_aline
amarone9311202amarone
amine75835382_amine
ammine10314492ammine
arene55329412_arene
arise56436432_arise
arsine64021042_arsine
azine146721412_azine
baring95135852baring
barite84224812barite
brine75132272_brine
canine83826702canine
caprine11314232caprine
carbine112918642carbine
caribe103416752caribe
carina84325322carina
carinae94318582carinae
caring95137992caring
carline93923612carline
carmine112918482carmine
carnie84421092carnie
daring84928682daring
earing75235482earing
famine114318192famine
farina94618232farina
faring105231282faring
ferine96422582ferine
gamine94620152gamine
haring104233002haring
harmine122816192harmine
imagine1037882imagine
jarina134014062jarina
latrine7715122latrine
lawine93316462lawine
machine14313492machine
macing114221552macing
madrone102812662madrone
maile75232222ma_ile
main65345522ma_in_
mains75635112ma_ins
maize164618562ma_ize
making134823852making
malice104818482malice
malines93625602malines
mamie95826002mami_e
mane65052032ma__ne
marble104219102marble
mare64759332mar__e
marge85328332mar_ge
margin94016842margin_
margined1237742margined
margins103815192margins
maria75032882mari_a
marinade11259382marinade
marinas93519382marinas
marinate103017782marinate
mariners103113862mariners
marish114319052marish
marking144020132marking
marlin84220902marlin_
marlines103818712marlines
marling103322762marling
marlins93420472marlins
marlite92917072marlite
marmite112413992marmite
marque172410502marque
marring103319552marring
marse76231152mar_se
marten84518262marten
martin84122522martin_
martinet10319642martinet
marting103325012marting
martini93613872martini
martins93322062martins
matin75132852matin_
matinee92415612matinee
mating94832912mating
matins84527782matins
mavie104722562mavi_e
mavin105722952mavin_
mavins115119182mavins
mawing124020802mawing
maxing164817072maxing
maxixe1435222maxixe
maying124421152maying
mazing184418972mazing
merino8315092merino
mine67256172m__ine
mirin75023152mirin_
miring93723802miring
mirins83918902mirins
moline84422032moline
moraine9314572moraine
murines93718222murines
muring95120372muring
murrine9411482murrine
mutine84420372mutine
nardine82712572nardine
oaring74225302oaring
pardine103616722pardine
paring94236492paring
patine85328122patine
purine85321892purine
rapine85023082rapine
raring74332872raring
ratine65131822ratine
ravine95522222ravine
sabine84020392sabine
saline65132702saline
sardine83317392sardine
sarin55239252sarin_
sarins63932622sarins
savine94220282savine
serine65432672serine
shrine94920052shrine
tacrine9311292tacrine
taring73932282taring
taurine7311362taurine
trine54734602_trine
urine55026602_urine
vahine123612112vahine
valine94623092valine
wahine123813012wahine
waring105029442waring

Search took 3 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 Filter178691825510.360496363.9
2DLD Change Limit825511342.53332590.2
3Display Results1341340.0462913.0
 (SQL Overall)1786911342.93960799.9
 
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.