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

350 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
trocar84877(None) 
trocars959041trocars
trochar1257071trochar
grocer94212142grocer
procarp1346822procarp
prowar114110942prowar
roar46328572_ro_ar
tolar55524112t_olar
tracer84820232tracer
tramcar1135592tramcar
troak95213572tro_ak
trochal1288242trochal
trochars1377852trochars
troche113112512troche
trock114817602troc_k
trocks123614632trocks
trona54118952trona_
tronas63816902tronas
trover95014662trover
turbocar1243362turbocar
apocarp1355133apocarp
areca75618633areca_
arecas84817453arecas
areolar779223areolar
aroma71220153aroma_
aromas81018623aromas
arrear6310253arrear
boar66134293_bo_ar
bolar75123473_bolar
boxcar1734753boxcar
boyar106013763_boyar
bracer104620583bracer
briar75718153br_iar
broach133611113broach
broad84817693bro_ad
brocade1238533brocade
broche133612103broche
brock136017073broc_k
brocks145214153brocks
brogan9311043brogan
broker124314243broker
bromal10313653bromal
calcar10312753calcar
car59165563___car
coca88030643_coca_
cocas95926573_cocas
croak115216633cro_ak
croc85723733croc__
croci95818133croc_i
crock135921993croc_k
crocks145118423crocks
crocs95722433croc_s
crocus104813173crocus
crowbar1444273crowbar
crower114117563crower
crozer175112843crozer
deodar837713deodar
drear65016903dr_ear
droner74717673droner
drover104614593drover
erica7316543erica_
ericas8315463ericas
escar74011993_escar
exocarp1843853exocarp
focal104917673_focal
forcer114917343forcer
fracas11311993fracas
friar85414273fr_iar
frock145314653froc_k
frocks154111213frocks
froward1436673froward
groan65618423gro_an
groat65531973gro_at
grocers103511253grocers
grocery13336763grocery
groper94517253groper
grower104614933grower
hoar76729163_ho_ar
ironer64216453ironer
isobar836143isobar
jowar155211433_jowar
krona93611793krona_
kroner104612573kroner
kronor10417233kronor
kronur10415313kronur
lascar868573lascar
lobar7313013_lobar
loca65527683_loca_
local74820273_local
molar75223093_molar
mortar83812043mortar
motorcar1274543motorcar
oar37057953__o_ar
oca56731733__oca_
ocas66729633__ocas
orca65522773or_ca_
orcas75918623or_cas
osar46820953__osar
outroar739513outro_ar
polar75623453_polar
prewar114712583prewar
pricer103918293pricer
proa66229963pro_a_
proas75028803pro_as
prober104516073prober
procarps1445973procarps
proctor11310433proctor
procure1138573procure
prolan8414693prolan
proper104319953proper
proser84223463proser
prover113819723prover
prower114218123prower
racer75233023_racer
radar61316723_radar
rear45644553_r_ear
rebar75420193_rebar
recap95718023_recap
recur74116843_recur
ricer74726613_ricer
roach105717003_roach
road56332113_ro_ad
roam67132413_ro_am
roan47234203_ro_an
roars55622243_ro_ars
roc520243253_roc__
rock105735183_roc_k
rocker124319573_rocker
rocks114626413_rocks
rocky144513853_rocky
rocs65533663_roc_s
roger64521413_roger
roman75424823_roman
roper75431913_roper
rosary92810353_rosary
rota45834343_rota_
rotary92411303_rotary
rotas54827723_rotas
rotor55519733_rotor
rover85527373_rover
rowan85418733_rowan
rower85430493_rower
royal85014703_royal
scar66434203__scar
serovar1046143serovar
shofar1236313shofar
soar46838673_so_ar
soca66330053_soca_
socas74026183_socas
sofar86115493_sofar
solar55927343_solar
sonar56523423_sonar
soucar839323soucar
sowar85821343_sowar
sowcar1135863sowcar
stroker114113523stroker
stroma84313073stroma_
stromal93010593stromal
stroyer103510783stroyer
talar56225383t_alar
tar37570693t___ar
taroc75721643taroc__
tarocs84615663taroc_s
tartar63214763tartar
tatar56122063t_atar
teacart91113193teacart
tear45242883t__ear
teopan839353teopan
theca103311453theca_
thecae11299653thecae
thecal113310313thecal
thenar92610003thenar
thorax1638253thorax
throat94819753thro_at
thrower1387003thrower
tical76021493t_ical
tincal83913373tincal
tipcart1148833tipcart
tipcat10312653tipcat
toad55830183t_o_ad
tocher114014913t_ocher
today96416953t_oday
toea46732333t_oea_
toeas55726423t_oeas
toecap1037323toecap
toga57027413t_oga_
togae67020113t_ogae
togas67823003t_ogas
tokay125513053t_okay
toker95924913t_oker
tola45236333t_ola_
tolan55124013t_olan
tolars64817943t_olars
tolas54532773t_olas
toman75724053t_oman
tomcat101013453tomcat
tonal53724303t_onal
toner55336243t_oner
toolbar944773toolbar
tooler63818613tooler
tooter64420803tooter
topaz16315323t_opaz
toper75231023t_oper
tor39261683t_o__r
tora47545993t_ora_
torah87125273t_orah
toras55540373t_oras
torc66333353torc__
torch107420933torc_h
torchy14549533torchy
torcs75123763torc_s
torpor839193torpor
torr45630903t_o_rr
torta55925353torta_
tortas64918253tortas
total55321823t_otal
toter55932133t_oter
toucan838193toucan
tour45530383t_o_ur
toward10311063t_oward
tower85729203t_ower
toyer84521553t_oyer
trace75829613trac_e
traced94821583traced
tracers94917843tracers
tracery12399793tracery
traces85329933traces
track114823013trac_k
tracker133515173tracker
tracks124818843tracks
tract75635713trac_t
tractor9311343tractor
tracts85019073tracts
trad55630913tr__ad
trader75218763trader
tram67034553tr__am
tramcars1245233tramcars
trap67532803tr__ap
trapan82412973trapan
tray77632593tr__ay
tread64821703tr_ead
treat56240353tr_eat
trefah1235093trefah
tremor84210403tremor
trepan82511673trepan
triac74116373tr_iac
triacs83913223triacs
triad65217723tr_iad
trial54926353tr_ial
tribal8611133tribal
trice75127493tric_e
triced95518673triced
tricep103911073tricep
trices84826333trices
trick115420693tric_k
tricker134615523tricker
tricks125319013tricks
tricky154211473tricky
triclad1037443triclad
tricorn937963tricorn
tricot8317753tricot
trier54328533tr_ier
trifocal1345033trifocal
trimer85717153trimer
trinal6516963trinal
trinary1039173trinary
tripart9311433tripart
triter65120593triter
troaks104410603troaks
trochaic1546943trochaic
trochee122613883trochee
troches123715343troches
trochil1258713trochil
trochlear1443453trochlear
trocked144312243trocked
trod57627953tro__d
trode65322853tro_de
troffer13125863troffer
trog57628213tro__g
trogon73611753trogon
trogs67022603tro_gs
troika1035493troika
troikas1135033troikas
trois57226093tro_is
troke94821053tro_ke
troked114114583troked
trokes104019263trokes
troland837543troland
troll54416533tro_ll
troller73913173troller
trolls64613943trolls
trolly94012363trolly
tromp95815803tro_mp
trompe105611263trompe
tromps104911703tromps
trone55131863tro_ne
trones65629283trones
troop76417533tro_op
trooper94210363trooper
troops85712783troops
trooz145016153tro_oz
trop66833303tro__p
trope75725803tro_pe
tropes84824353tropes
trophy1438283trophy
tropic103014193tropic
tropical1248733tropical
tropin83316753tropin
trot46351313tro__t
troth85622203tro_th
troths95414153troths
trots56629943tro_ts
trotter73312253trotter
trotyl9236673trotyl
trough108512033trough
trouncer1035443trouncer
troupe84812433troupe
trouper93811433trouper
trouser73812473trouser
trout57332573tro_ut
trouts66116633trouts
trouty95211793trouty
trove85221923tro_ve
trovers103713323trovers
troves94719113troves
trow78031423tro__w
trowed104714653trowed
trowel94211463trowel
trows88826183tro_ws
trowth1277883trowth
troy77429683tro__y
troys86418613tro_ys
truce75118693truc_e
truced95312053truced
truces84916333truces
truck116115463truc_k
trucker134010733trucker
trucks124711973trucks
truer54916643tr_uer
tryma1037223tryma_
tsar47819803t__sar
turbocars1343073turbocars
tussar6369543tussar
twofer1234353twofer
tzar136315373t__zar
uproar8106933upro_ar
vicar10513863_vicar
vocab12409973_vocab
vocal104715643_vocal
volar86917413_volar

Search took 7 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 Filter1786911127160.373479064.3
2DLD Change Limit1127163505.78319490.9
3Display Results3503500.1063301.9
 (SQL Overall)1786913506.26228535.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.