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

101 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
trochils138858(None) 
trochil1258711trochil_
trochili1376941trochili
trochilus1474711trochilus
archils12510532ar_chils
orchils1277702or_chils
trochaics1645062trochaics
trochal1288242trochal_
trochars1377852trochars
trochees132510182trochees
troches123715342troch_es
trochoids1546602trochoids
trophies13413672trophies
archil11611573ar_chil_
atrophias1447933atrophias
atrophies14410093atrophies
biochips1744843biochips
brachials16206943brachials
brocolis1247303brocolis
broils84114173bro__ils
brothels13277073brothels
cochins141413103_cochins
croceins1238103croceins
crochets15359833crochets
frothily1745303frothily
glochids1543953glochids
grouchily1842843grouchily
hoochies1639603hoochies
mochila1446523_mochila
mochilas1544953_mochilas
orchids1377213or_chids
orchil1158653or_chil_
orchis11710773or_chi_s
prechill1546193prechill
prechills1645123prechills
rachis114017653_rachi_s
recoils93814873_recoils
rochets124213473_rochets
roils54826793_ro__ils
roshis9311793_roshi_s
strobils1046563stro_bils
techies12513603t_echies
techily1537123t_echily
tetchily1644123tetchily
tochers123413093t_ochers
tocsins939963t_ocsins
toils54527493t_o__ils
tonsils7310183t_onsils
toothily1445523toothily
torches123715433torch_es
torchier1337463torchier
torchiers1445073torchiers
torchiest1438033torchiest
torching142510083torching
torchons1337503torchons
touchily1645233touchily
tracheas13410273tracheas
tracheids1545053tracheids
trachle12311853trach_le
trachles13311753trachles
tractile10311073tractile
trails64622513tr__ails
trashily1437323trashily
travails1146083travails
trefoils1145303trefoils
trenails869843trenails
trichina1348093trichina
trichinas1446043trichinas
trichite1349333trichite
trichites1448883trichites
trickily1736233trickily
trocars959043troc_ars
trochaic1546943trochaic
trochar1257073troch_ar
troche113112513troch__e
trochee122613883troch_ee
trochlea1345193trochlea
trochleas1444713trochleas
trochoid1468443trochoid
trocking153612423trocking
trocks123614633troc__ks
troilus736413tro__ilus
trois57226093tro__i_s
trollies8310233trollies
trolls64613943tro__lls
trommels12254333trommels
troopials1143833troopials
trophic14311033trophi_c
trophied1437643trophied
tropics113610653tro_pics
tropins93116313tro_pins
trothing122410843trothing
troths95414153troth__s
trotyls10236033tro_tyls
troupials1142933troupials
trowels10358363tro_wels
trysails1144163trysails
turophile1475883turophile
turophiles1565983turophiles
uracils939373urac_ils
urchins1238863ur_chins

Search took 9 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.436409841.7
2DLD Change Limit1461621017.58019282.6
3Display Results1011010.0303366.7
 (SQL Overall)1786911018.04622208.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.