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

95 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
tinstone84817(None) 
tinstones948491tinstones
histone10312842hi_stone
inkstone1245412_inkstone
intone61115432_in_tone
oilstone847272oilstone
sunstone847792sunstone
topstone1046882topstone
turnstone944472turnstone
veinstone1253852veinstone
whinstone1544272whinstone
bondstone1275523bondstone
brimstone1354623brimstone
burstone1057133burstone
capstone1237653capstone
clingstone1352683clingstone
diastole947563diastole
distome10313233di_stome
dripstone1244153dripstone
drystone1245123drystone
earstone848603earstone
eyestone1146533eyestone
felstone1146863felstone
firestone1247423firestone
gemstone1145843gemstone
grindstone1252633grindstone
hailstone1244853hailstone
histones11312803hi_stones
hornstone1266073hornstone
inkstones1345083_inkstones
insane6314893_ins_ane
inshore1038723_inshore
insigne837673_insigne
insole63515863_ins_ole
instance1049883_instance
instant7815353_instant
instate71616483_instate
instroke1245583_instroke
intine61021983_in_tine
intoned8811993_in_toned
intoner7811673_in_toner
intones7816543_in_tones
ironstone945753ironstone
isotone7239983_isotone
keystone1545333keystone
limestone1144813limestone
linstock1444433linstock
milestone1146433milestone
millstone1145423millstone
minestrone1254453minestrone
misatone1049763misatone
misdone10310863mi_sdone
mistune9310653mi_stune
monotone10310153monotone
moonstone1146143moonstone
mudstone1145553mudstone
oilstones946613oilstones
pensione1039773pensione
pinbone1138183pin_bone
pinecone1246063pinecone
pipestone1345503pipestone
pistole92414313pi_stole
piston83515923pi_ston_
pistons93016373pi_stons
potstone1039423potstone
rhinestone1353223rhinestone
ringbone1144953ringbone
sandstone1045643sandstone
siltstone943913siltstone
sinsyne1043303sins_yne
stone55431183___stone
sunstones947883sunstones
tension7311803tension_
tensioned1045613tensioned
tensioner945913tensioner
tensions8310223tensions
teston6313303t_eston_
testons7313563t_estons
tincting1148883tincting
tincture1044673tincture
tinting84620603tin_ting
tintype1243033tin_type
tipstock1643733tipstock
tiptoe838283ti_pto_e
tisane6311573ti_s_ane
toadstone1044583toadstone
tombstone1343813tombstone
tontine72316143ton_tine
topstones1147013topstones
tritone73613883t_ritone
turnstones1044303turnstones
unstoned9311043_unstoned
veinstones1363733veinstones
whinstones1644233whinstones
winsome1237463wins_ome

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.406440125.6
2DLD Change Limit146162956.67321903.5
3Display Results95950.0303166.7
 (SQL Overall)178691957.10925135.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.