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

122 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
marines9392801(None) 
malines93625601malines
marinas93519381marinas
marine84230401marine_
mariner93315991mariner
mariners103113861mariners
marlines103818711marlines
murines93718221murines
acarines10314342acarines
alines65735222_alines
amarones10311352amarones
amines84727982_amines
ammines11312672ammines
arenes64928392_arenes
arises65233802_arises
arsines73518812_arsines
azines155517072_azines
barites94322332barites
brines85028852_brines
canines93724032canines
carbines123617532carbines
caribes113715642caribes
carices114220952carices
caries85147622cari_es
carinas93622402carinas
carlines103521642carlines
carmines123617862carmines
carnies94123962carnies
darings93713652darings
earings84517712earings
famines123216262famines
farinas103215232farinas
gamines103618462gamines
harmines132715142harmines
imagines1137462imagines
jarinas143712182jarinas
larine63927042larine_
latrines8515002latrines
lawines103313562lawines
machines15312892machines
madrones112912282madrones
mailes84329112ma_iles
mains75635112ma_in_s
maizes175115732ma_izes
makings145413162makings
malices114316622malices
maline84529082maline_
mamies104626242mami_es
manes76648962ma__nes
marbles114516652marbles
marches143921172marches
mares76457632mar__es
marges94525712mar_ges
margined1237742margined
margins103815192margin_s
marina84623412marin_a
marinades12268972marinades
marinates112516382marinates
marishes13512552marishes
markings153410242markings
marline93320952marline_
marlings113713492marlings
marlins93420472marlin_s
marlites103415262marlites
marmites122212792marmites
marques182610862marques
marries93825282marries
marses84827112mar_ses
marshes123615372marshes
martens93714952martens
martinet10319642martinet
martinets1138882martinets
martinis103311612martinis
martins93322062martin_s
matinee92415612matinee
matinees102110422matinees
matiness102114752matiness
matings104516212matings
matins84527782matin_s
matrices12312082matrices
matrixes1738062matrixes
mavies114923192mavi_es
mavins115119182mavin_s
mavises122812992mavises
maxixes1535252maxixes
mayings134410512mayings
maziness19239542maziness
merinos9311982merinos
merises93421422merises
mines75651952m__ines
miriness10310462miriness
mirins83918902mirin_s
moraines10314362moraines
murices112612282murices
murine84220022murine_
mutines93117822mutines
narine63422552narine_
paries84742512pari_es
parings104219212parings
parises94827182parises
patines95225762patines
purines94420762purines
rapines95120862rapines
ratines75328582ratines
ravines104220232ravines
sabines94318482sabines
salines74029412salines
sardines92815562sardines
sarins63932622sarin_s
savines104417632savines
serines74229542serines
shrines104618692shrines
tacrines10310562tacrines
taurines8310552taurines
trines64132562_trines
urines64724122_urines
vahines133410522vahines
valines104520212valines
varices123313572varices
varies94330872vari_es
wahines133111172wahines
wariness11313212wariness

Search took 4 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 Filter1786911076710.360496363.9
2DLD Change Limit1076711223.09334811.2
3Display Results1221220.0462652.2
 (SQL Overall)1786911223.49951069.2
 
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.