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

82 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
volatile114643(None) 
volatiles1246131volatiles
violative1545112violative
vocative1637912vocative
volatilise1354292volatilise
volatilize2254102volatilize
volitive1446892volitive
ablative1348243ablative
conative131214623conative
dilative1239523dilative
donative12139873donative
elative10312453_elative
eolipile1045093eolipile
eolopile1045863eolopile
evocative1746293evocative
folate93320393folat__e
folktale1542873folktale
gelatine93213313gelatine
holytide1544973holytide
hostile10312553ho_stile
illative1147183illative
joltily1746323jol_tily
labile8315223__labile
locative1338683locative
motile83818343mo__tile
nonvolatile1453173nonvolatile
palatine10316073palatine
polarise10513903polarise
polarize19512653polarize
pulsatile1173393pulsatile
relative11313143relative
rolamite1048743rolamite
rotative11310343rotative
saxatile1544953saxatile
solanine8311533solanine
solarise8512543solarise
solarize17511473solarize
solate64526073solat__e
solatia7312253solati_a
solating9315593solating
solation8916153solation
solatium1067613solatium
solstice1047223solstice
sonatine8313323sonatine
tortile7313193to_rtile
vagile10310543v__agile
velarize2048763velarize
velate93720143velat__e
versatile1245163versatile
vibratile1443663vibratile
violable1337543viola_ble
violate10311553violat__e
violating1337443violating
violation1238443violation
vocable14189673voca_ble
vocalise131510813vocalise
vocalize221310153vocalize
vocation132311983vocation
vocatives1745883vocatives
voile84719723vo___ile
volante1038513vola_nte
volatilised1552953volatilised
volatilises1454403volatilises
volatility1644863volatility
volatilized2453773volatilized
volatilizes2354183volatilizes
volcanize2345733volcanize
volition1179173volition
voltage1136863vol_tage
voltaic1245453voltai_c
voltaism1344813voltaism
volte85321303vol_t__e
volti84915963vol_ti__
voluble1244503vol_uble
volute93912763volut__e
volutin1098103voluti_n
volutins1188003volutins
volution1198603volution
volvate13317993volvat__e
vomitive1645853vomitive
votable122111373vota_ble
votive12348933vo__tive

Search took 8 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 Limit146162827.17320376.7
3Display Results82820.0302733.3
 (SQL Overall)178691827.65623340.0
 
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.