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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

84 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
marinas9351940(None) 
carinas93622421carinas
farinas103215251farinas
jarinas143712201jarinas
marina84623411marina_
marines93928031marines
amritas939102amritas
arenas65022012_arenas
arias55438042_ari_as
carina84325332carina_
carinae94318592carinae
carinal94318242carinal
caritas93316962caritas
czarinas1935302czarinas
darings93713652darings
earings84517712earings
farina94618232farina_
farinhas14325372farinhas
harianas1139172harianas
jarina134014062jarina_
laminas93615872laminas
latinas74416462latinas
madronas11288492madronas
mafias113913572mafi_as
magians10310752magians
mains75635112ma_in_s
makings145413162makings
malines93625612malines
mananas93414732mananas
manas76240432ma__nas
manias84029032mani_as
manilas93915872manilas
mannas85019802ma_nnas
maracas11313772maracas
marantas10310032marantas
maras75443302mar__as
marginal1137612marginal
marginals1246022marginals
margins103815192margin_s
maria75032892mari_a_
marimbas1444362marimbas
marinade11259382marinade
marinades12268982marinades
marinara1046492marinara
marinaras1145572marinaras
marinate103017782marinate
marinates112516392marinates
marine84230412marin_e
mariner93316002mariner
mariners103113872mariners
marital92314182marital
markas124717012mar_kas
markings153410242markings
markkas12356082markkas
marlines103818742marlines
marlings113713502marlings
marlins93420482marlin_s
martians103111612martians
martinis103311612martinis
martins93322062martin_s
matinal9312602matinal
matings104516212matings
matins84527782matin_s
mavins115119182mavin_s
mayings134410512mayings
medinas103411462medinas
merinos9311982merinos
minas75434112m__inas
mirins83918902mirin_s
murines93718222murines
myricas1436752myricas
ocarinas1036732ocarinas
parians93519742parians
parings104219222parings
patinas96318532patinas
salinas73116092salinas
sarcinas1039292sarcinas
sarins63932622sarin_s
tsarinas835272tsarinas
tzarinas1733972tzarinas
vaginas11298812vaginas
varias95019912vari_as
varnas94212832var_nas
zaribas1836042zaribas

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.373479064.3
2DLD Change Limit107671843.09634777.5
3Display Results84840.0302800.0
 (SQL Overall)178691843.49951069.2
 
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.