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

99 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
trochars137785(None) 
trocars959041troc_ars
trochar1257071trochar_
tochers123413092t_ochers
trocar848772troc_ar_
trochaic1546942trochaic
trochaics1645062trochaics
trochal1288242trocha_l
trochees132510182trochees
troches123715342troch_es
trochils1388582trochils
trochlears1543142trochlears
archers124414573ar_chers
armchairs1642573armchairs
brechams1745773brechams
brechans1547413brechans
broachers16328153broachers
brochure1544353brochure
brochures1644413brochures
brothers133410833brothers
chars105936643___chars
clochard1644293clochard
clochards1743823clochards
cochairs1545903_cochairs
crochets15359833crochets
crowbars1544433crowbars
eschars1237173_eschars
frothers14279813frothers
grocers103511253groc_ers
isochors1355673isochors
lochans1248833_lochans
mochas13310663_mocha_s
moochers15369123moochers
ochers113915303__ochers
orchard1346933or_chard
orchards1445913or_chards
pochard1537363_pochard
pochards1646853_pochards
procarp1346823proc_arp
procarps1445973proc_arps
prochain1548483prochain
proctors12311513proctors
rechart12314323_rechart
recharts1337663_recharts
roars55622243_ro__ars
rochets124213473_rochets
rockers133916553_rockers
shophars1646353shophars
teachers133212393teachers
tocher114014913t_ocher_
tolars64817943t_o_lars
toolbars1044743toolbars
torchere1347683torchere
torcheres1446863torcheres
torches123715433torch_es
torchiers1445073torchiers
torchons1337503torchons
touchers133611213touchers
tracers94917843trac_ers
tracheary1744803tracheary
tracheas13410273tracheas
trachles13311753trachles
trackers143512853trackers
tractors10312563tractors
tramcars1245233tramcars
trashers113013643trashers
trenchers14288073trenchers
trickers143812813trickers
triclads1146233triclads
trishaws1444003trishaws
troaks104410603tro__aks
trochanters1653433trochanters
troche113112513troch__e
trochee122613883troch_ee
trochil1258713troch_il
trochili1376943trochili
trochilus1474713trochilus
trochlea1345193trochlea
trochlear1443453trochlear_
trochleas1444713trochleas
trochoid1468443trochoid
trochoids1546603trochoids
trocks123614633troc__ks
troffers14125433troffers
troikas1135033troika_s
trollers83211213trollers
tronas63816903tro_na_s
troopers10289443troopers
trophies13413673trophies
troths95414153troth__s
trotters83310243trotters
troupers10359443troupers
trousers83910633trousers
trovers103713323tro_vers
trowsers11428003trowsers
truckers14279013truckers
turbocars1343073turboc_ars
urochord1444453urochord
urochords1544213urochords

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.1561145455.1
2DLD Change Limit146162997.18620339.8
3Display Results99990.0462152.2
 (SQL Overall)178691997.38824186.7
 
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.