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

143 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
tricorn93796(None) 
tricorne1045961tricorne
tricorns1036681tricorns
bicorn103610102_bicorn
tricornes1146232tricornes
tricot8317752trico_t
tricots9311562tricots
triform1237852triform
trigon74513102trigo_n
triton63914892trito_n
unicorn946512unicorn
acorn75616623__acorn
bicorne11297553_bicorne
bicorns11338763_bicorns
bicron103710773_bicron
bricole112810493bricole
bridoon1046203bridoon
cavicorn1543833cavicorn
chicory1735993chicory
corn69945813___corn
cricoid1239243cricoid
ericoid1049893ericoid
grison7310103griso_n
icon66922043__ico_n
lyricon1243713lyrico_n
micron103714283_micron
omicron1165063omicron
orison6411663oriso_n
popcorn1344903popcorn
preworn124711223preworn
pricer103918293pricer_
pricers113915063pricers
prion75119993pri_o_n
prior74316173pri_or_
priors83914483pri_ors
priory114110263pri_ory
prison8514023priso_n
racon75422143_raco_n
racoon83814473_racoon
reborn810016963_reborn
recoin84320293_recoin
recon75624243_reco_n
record96117433_record
recork126315493_recork
retorn610923433_retorn
reworn98122203_reworn
ricer74726613_ricer_
ricers84120993_ricers
richen113812513_richen
ricin74620213_ric_in
rigor62714053_rigor_
rigors72813713_rigors
ripcord1264463_ripcord
scorn75817453__scorn
stricken1436893stricken
stridor8467393stridor_
stridors9367323stridors
tailor63412503tailor_
tailors73212393tailors
thicken16317873thicken
thorn85318703t__horn
tigon63914443t_igo_n
tinhorn1046033tinhorn
toilworn1143583toilworn
torn46044253t___orn
tracer84820233tracer_
tracers94917843tracers
tracery12399793tracery
tractor9311333tractor_
tractors10312563tractors
traitor7310123traitor_
traitors8310793traitors
tremor84210403tremor_
tremors93711233tremors
triazin1638203triazin
trice75127493tric__e
triced95518673tric_ed
tricep103911073tric_ep
triceps11267343triceps
trices84826333tric_es
trichina1348093trichina
trichoid1457813trichoid
trichome1596953trichome
tricing103417353tricing
trick115420693tric__k
tricked144016163tricked
tricker134615523tricker
trickers143812813trickers
trickery17297343trickery
trickie132611033trickie
tricking152714513tricking
trickle133613443trickle
trickly16369893trickly
tricks125319013tric_ks
tricksy16436583tricksy
tricky154211473tric_ky
triclad1037443triclad
triclosan11103283triclosan
tricolor10115833tricolor
tricolors11125803tricolors
tricotine1148253tricotine
trictrac1244413trictrac
trier54328533tri_er_
triers64321523tri_ers
trifold1136243trifold
triforia1145643triforia
trigo65716053trigo__
trigons84312093trigons
trigos74214173trigo_s
trilogy1136013trilogy
trimaran1045643trimaran
trimer85717153trimer_
trimers94615143trimers
trimorph1543623trimorph
trinary1039173trinary
trio45233343tri_o__
triode75311893tri_ode
triol55521363tri_o_l
triols66117803tri_ols
trios55528093tri_o_s
triose64715383tri_ose
tripart9311433tripart
tripod9399853tripo_d
tripods10359053tripods
tripody13395983tripody
tripoli937133tripoli
tripos84014923tripo_s
triptan947543triptan
trisome9310223trisome
trisomy1235943trisomy
triter65120593triter_
tritoma948053tritoma
tritone73613883tritone
tritons73814883tritons
trocar848773trocar_
trocars959043trocars
trogon73611753trogo_n
trueborn1043063trueborn
turion6313163turi_o_n
twinborn1341903twinborn
tycoon1136023t_ycoon
unicorns1044773unicorns
zircon1754953zirco_n

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.403443402.0
2DLD Change Limit1340271437.17318684.9
3Display Results1431430.0463108.7
 (SQL Overall)1786911437.62223444.1
 
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.