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

104 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
tricorns103668(None) 
tricorn937961tricorn_
tricorne1045961tricorne
tricornes1146231tricornes
bicorns11338762_bicorns
tricots9311562trico_ts
trigons84312092trigo_ns
tritons73814882trito_ns
unicorns1044772unicorns
acorns85013013__acorns
bicorn103610103_bicorn_
bicorne11297553_bicorne
bicornes12307253_bicornes
bicrons113410473_bicrons
bricoles122610303bricoles
bridoons1145423bridoons
corns76034763___corns
cricoids1347183cricoids
grisons838993griso_ns
icons76516493__ico_ns
lyricons1343583lyrico_ns
microns113814783_microns
omicrons1275193omicrons
orisons7310563oriso_ns
popcorns1444023popcorns
pricers113915063pricer_s
prions84317783pri_o_ns
priors83914483pri_or_s
prisons9313223priso_ns
racons84319343_raco_ns
racoons93912433_racoons
recoins94019243_recoins
recons84922993_reco_ns
records105213923_records
recorks134813023_recorks
ricers84120993_ricer_s
richens12349733_richens
ricins83618703_ric_ins
rigors72813713_rigor_s
ripcords1344073_ripcords
scorns85713023__scorns
stridors9367323stridor_s
tailors73212393tailor_s
thickens17266413thickens
thorns95314103t__horns
tigons74112263t_igo_ns
tinhorns1145013tinhorns
tracers94917843tracer_s
tractors10312563tractor_s
traitors8310793traitor_s
tremors93711233tremor_s
triazins1738353triazins
triceps11267343tric_eps
trices84826333tric__es
trichina1348093trichina
trichinas1446043trichinas
trichomes16107553trichomes
trichoses14107963trichoses
trichosis14106443trichosis
tricing103417353tric_ing
trickers143812813trickers
tricking152714513tricking
trickles143013763trickles
tricks125319013tric__ks
triclads1146233triclads
triclosans12142953triclosans
tricolor10115833tricolor
tricolors11125803tricolors
tricot8317753trico__t
tricotine1148253tricotine
tricotines1247453tricotines
trictrac1244413trictrac
trictracs1344043trictracs
triens65417543tri__ens
triers64321523tri_er_s
triforia1145643triforia
triform1237853trifor_m
trigon74513103trigo_n_
trigos74214173trigo__s
trimarans1144693trimarans
trimers94615143trimer_s
trimorph1543623trimorph
trimorphs1643783trimorphs
triodes84012503tri_odes
triols66117803tri_o_ls
trios55528093tri_o__s
trioses75015653tri_oses
tripods10359053tripo_ds
tripolis1038713tripolis
tripos84014923tripo__s
triposes1039973triposes
triptans1047363triptans
trisomes1039833trisomes
tritomas1048033tritomas
triton63914893trito_n_
tritone73613883trito_ne
tritones83413443tritones
trocars959043trocar_s
trogons83410723trogo_ns
tryworks1844603tryworks
turions7311573turi_o_ns
tycoons1235173t_ycoons
unicorn946513unicorn_
zircons1854963zirco_ns

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.423422437.4
2DLD Change Limit1461621046.89021213.6
3Display Results1041040.0462260.9
 (SQL Overall)1786911047.35924282.0
 
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.