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 “oilstone” 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
oilstone84727(None) 
oilstones946611oilstones
felstone1146862felstone
hailstone1244852hailstone
histone10312842hi_stone
milestone1146432milestone
millstone1145422millstone
siltstone943912siltstone
tinstone848172tinstone
biltong1034683bil_tong
bondstone1275523bondstone
brimstone1354623brimstone
burstone1057133burstone
capstone1237653capstone
copestone1397453copestone
diastole947563diastole
distome10313233di_stome
dripstone1244153dripstone
drystone1245123drystone
earstone848603earstone
eyestone1146533eyestone
felstones1246963felstones
fieldstone1452133fieldstone
firestone1247423firestone
footstone1245273footstone
gallstone1044823gallstone
gemstone1145843gemstone
goldstone1194663goldstone
goldtone1084593goldtone
hailstones1344983hailstones
halftone1445153halftone
histones11312803hi_stones
holystone1555473holystone
hornstone1266073hornstone
inkstone1245413inkstone
intone61115433_i_ntone
isotone7239983_isotone
keystone1545333keystone
kiloton1196313kiloton_
kilotons1286313kilotons
limestone1144813limestone
loadstone1044493loadstone
lodestone1045323lodestone
marlstone1144593marlstone
milestones1246373milestones
millstones1245353millstones
misatone1049763misatone
misdone10310863mi_sdone
mistune9310653mi_stune
moonstone1146143moonstone
mudstone1145553mudstone
oestrone849973o_estrone
oilhole1046263oil_hole
oilskin1144473oilskin_
oilskins1243873oilskins
outshone1149343outshone
overtone111012573overtone
oxytone1744203o_xytone
pipestone1345503pipestone
pistole92414313pi_stole
piston83515923pi_ston_
pistons93016373pi_stons
potstone1039423potstone
silicone1096733silicone
siltstones1043873siltstones
soapstone1144143soapstone
stone55431183___stone
sunstone847793sunstone
tinstones948493tinstones
toadstone1044583toadstone
toilsome1045203toils_ome
tombstone1343813tombstone
topstone1046883topstone
veinstone1253853veinstone
whinstone1544273whinstone

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.420425454.8
2DLD Change Limit146162756.95321021.4
3Display Results75750.0332272.7
 (SQL Overall)178691757.40624127.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.