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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

108 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
trochar125706(None) 
trocar848761troc_ar
trochal1288241trochal
trochars1377841trochars
tocher114014912t_ocher
trocars959022troc_ars
trochaic1546942trochaic
troche113112512troch_e
trochee122613872trochee
troches123715342troches
trochil1258712trochil
trochlear1443452trochlear
archer115016243ar_cher
armchair1543023armchair
brecham1646833brecham
brechan1437223brechan
broacher15329263broacher
broche133612103broch_e
brochure1544353brochure
brother123311333brother
char95132153___char
clochard1644293clochard
cochair1446313_cochair
crochet143616663crochet
crowbar1444253crowbar
epochal1445243epochal
eschar1136523_eschar
frother133110153frother
grocer94212143groc_er
isochor1244743isochor
lochan1139093_lochan
mocha1249923_mocha_
mochas13310653_mochas
moocher143610673moocher
ocher104516103__ocher
orchard1346933or_chard
pochard1537363_pochard
procarp1346823proc_arp
prochain1548483prochain
proctor11310433proctor
prowar114110943pro_war
rechart12314323_rechart
richer114015043_richer
roar46328573_ro__ar
rochet115423003_rochet
rocker124319573_rocker
shophar1555453shophar
teacher123714833teacher
tochers123413093t_ochers
tolar55524113t_o_lar
toolbar944763toolbar
torch107420933torch__
torched133511353torched
torchere1347673torchere
torches123715433torches
torchier1337463torchier
torchon1237363torchon
torchy14549533torch_y
tother94117143t_other
toucher124814353toucher
tracer84820233trac_er
trachea12311673trachea
tracheae1349103tracheae
tracheal1348253tracheal
tracheary1744803tracheary
tracheas13410273tracheas
trachle12311853trachle
tracker133515173tracker
tractor9311333tractor
tramcar1135593tramcar
trasher104416123trasher
trencher13279313trencher
tricker134615523tricker
triclad1037443triclad
trishaw1344753trishaw
troak95213573tro__ak
trochaics1645053trochaics
trochanter1544403trochanter
trochees132510183trochees
trochili1376943trochili
trochils1388583trochils
trochlea1345193trochlea
trochleae1444173trochleae
trochlears1543133trochlears
trochleas1444713trochleas
trochoid1468443trochoid
trock114817603troc__k
trocked144312243trocked
trocks123614633troc_ks
troffer13125863troffer
troika1035493troika_
troikas1135023troikas
troller73913173troller
trona54118953tro_na_
tronas63816893tro_nas
trooper94210353trooper
trophic14311033trophic
trophy1438283troph_y
troth85622203troth__
trothed114010973trothed
troths95414153troth_s
trotter73312253trotter
trouper93811413trouper
trouser73812463trouser
trover95014663tro_ver
trucker134010733trucker
turbocar1243363turboc_ar
urochord1444453urochord

Search took 10 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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271088.87615099.9
3Display Results1081080.0462347.8
 (SQL Overall)1786911089.07819684.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.