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

120 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
trochil125871(None) 
trochal1288241trochal
trochili1376941trochili
trochils1388581trochils
archil11611572ar_chil
orchil1158652or_chil
trochaic1546942trochaic
trochar1257072trochar
troche113112512troch_e
trochee122613882trochee
troches123715342troches
trochilus1474712trochilus
trochoid1468442trochoid
trophic14311032trophic
archils12510533ar_chils
atrophia1348103atrophia
atrophic1549373atrophic
biochip1645323biochip
brachia141910423brachia
brachial15219303brachial
broche133612103broch_e
brocoli1146353brocoli
broil74918223bro__il
bronchi14176313bronchi_
bronchia15195993bronchia
bronchial16175333bronchial
brothel12318193brothel
cochin131313203_cochin
crocein1138073crocein
crochet143616663crochet
croci95818133croc_i_
epochal1445243epochal
frothily1745303frothily
glochid1445263glochid
grouchily1842843grouchily
hoochie1537803hoochie
lochia1158313_lochia
lochial1257083_lochial
mochila1446523_mochila
orchid1289573or_chid
orchils1277703or_chils
orchis11710773or_chis
parochial1646183parochial
prechill1546193prechill
prochain1548483prochain
prochein1547523prochein
rachial122012173_rachial
rachis114017653_rachis
recoil84016723_recoil
rochet115423003_rochet
roil46235293_ro__il
roshi8310753_roshi_
roshis9311793_roshis
strobil936963stro_bil
strophic1569003strophic
techie11511723t_echie
techily1537123t_echily
tetchily1644123tetchily
tocher114014913t_ocher
tocsin8311003t_ocsin
toil46536283t_o__il
tonsil6311873t_onsil
toothily1445523toothily
tophi105215303t_ophi_
torch107420933torch__
torched133511353torched
torches123715433torches
torchier1337463torchier
torching142510083torching
torchon1237363torchon
torchy14549533torch_y
touchily1645233touchily
trachea12311673trachea
tracheal1348253tracheal
tracheid1437583tracheid
trachle12311853trachle
tractile10311073tractile
trail55126773tr__ail
trashily1437323trashily
travail1036553travail
trefoil1066063trefoil
trenail7410813trenail
trichina1348093trichina
trichinal1445663trichinal
trichite1349333trichite
trichoid1457813trichoid
trickie132611033trickie
trickily1736233trickily
trocar848773troc_ar
trocars959043trocars
trochaics1645063trochaics
trochars1377853trochars
trochees132510183trochees
trochlea1345193trochlea
trochoidal1653563trochoidal
trochoids1546603trochoids
trock114817603troc__k
trocked144312243trocked
trocking153612423trocking
trocks123614633troc_ks
trois57226093tro__is
troll54416533tro__ll
trommel11315363trommel
troopial1045483troopial
trophied1437643trophied
trophies13413673trophies
trophy1438283troph_y
tropic103014193tro_pic
tropin83316753tro_pin
troth85622203troth__
trothed114010973trothed
trothing122410843trothing
troths95414153troth_s
trotyl9236673tro_tyl
troupial1044183troupial
trowel94211463tro_wel
trysail1044543trysail
turophile1475883turophile
uracil8311543urac_il
urchin1138743ur_chin

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271206.90619407.3
3Display Results1201200.0462608.7
 (SQL Overall)1786911207.10825139.4
 
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.