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

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

75 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
rolamite104874(None) 
rolamites1148241rolamites
calamite12312532calamite
dolomite1148132dolomite
prolamine131510562prolamine
allanite8411093allanite
bedlamite1443193bedlamite
boehmite1583153boehmite
boracite1249193boracite
calamine12314033calamine
calamites13410713calamites
calamity1547753calamity
catamite12510593catamite
columbite1543973columbite
dolerite9611773dolerite
dolomites1248083dolomites
dopamine1346173dopamine
dynamite1444813dynamite
folate93320393fola__te
folkmote1763343folkmote
fomite113314073fo__mite
iolite63221983iol__ite
lamiae84817453__lamiae
localite101411543localite
malamute1245893malamute
melamine12310303melamine
melanite10512033melanite
molality13118363molality
molarity13118903molarity
monazite1957083monazite
oogamete11184933oogamete
oolite63319603ool__ite
polarise10513903polarise
polarity131310403polarity
polarize19512653polarize
polemize2148673polemize
polite83625073pol__ite
polyamide1745583polyamide
polyamine1647213polyamine
prolamin12139753prolami_n
prolamines14159363prolamines
prolamins13159703prolamins
prolate9419793prola__te
protamine131310913protamine
ramate83921693r__amate
ramie75027823r__ami_e
ratite65022423r__atite
relate64033633rela__te
relative11313143relative
relumine1038933relumine
rhodamine1543553rhodamine
roadie72813813ro_adi_e
roaming103215793ro_aming
romaine9512123roma_ine
romanise10312133romanise
romanize19311013romanize
roomie83013873ro_omi_e
roommate1244863roommate
rotameter1145443rotameter
rotate63320343rota__te
rotative11310343rotative
ruralite848963ruralite
samite83020603__samite
sodalite9109593sodalite
sodamide1245453sodamide
sodomite11136913sodomite
solanine8311533solanine
solarise8512543solarise
solarize17511473solarize
solate64526073sola__te
somite84519373so__mite
totemite1046873totemite
volante1038513vola_nte
volatile1146433volatile
wolframite1851433wolframite

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.453394461.4
2DLD Change Limit146162758.04618165.8
3Display Results75750.0332272.7
 (SQL Overall)178691758.53220943.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.