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

275 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
trocars95904(None) 
trocar848771trocar_
trochars1377851trochars
grocers103511252grocers
procarp1346822procarp
procarps1445972procarps
roars55622242_ro_ars
tolars64817942t_olars
tracers94917842tracers
tramcars1245232tramcars
troaks104410602tro_aks
trochar1257072trochar_
troches123715342troches
trocks123614632troc_ks
tronas63816902trona_s
trovers103713322trovers
turbocars1343072turbocars
apocarp1355133apocarp
apocarps1474423apocarps
arecas84817443areca_s
aromas81018613aroma_s
arrears738843arrears
boars75229603_bo_ars
boxcars1834773boxcars
boyars115611983_boyars
bracers114616703bracers
briars84814823br_iars
broads94515153bro_ads
brocade1238533brocade
brocades1358713brocades
brocks145214153broc_ks
brogans1049663brogans
brokers133111913brokers
bromals1139743bromals
calcars11312653calcars
cars67364763___cars
cocas95926573_coca_s
croaks125812983cro_aks
crocks145118423croc_ks
crocs95722433croc__s
crocus104813173croc_us
crowbars1544443crowbars
crowers124614903crowers
crozers184111083crozers
deodars937623deodars
drears74614253dr_ears
droners84114383droners
drovers115212643drovers
ericas8315463erica_s
escars83913133_escars
exocarp1843853exocarp
exocarps1953473exocarps
forcers124215713forcers
fracas11311993fraca_s
friars93812093fr_iars
frocks154111213froc_ks
froward1436673froward
groans74815063gro_ans
groats74816653gro_ats
grocer94212143grocer_
grocery13336763grocery
gropers104813853gropers
growers113612723growers
hoars85925553_ho_ars
ironers74813553ironers
isobars936593isobars
jowars16369653_jowars
lascars979013lascars
locals83714503_locals
molars85517323_molars
mortars93411523mortars
motorcars1394473motorcars
oars46846033__o_ars
ocas66729633__oca_s
orcas75918623or_ca_s
outroars838923outro_ars
polars84419353_polars
pricers113915063pricers
proas75028803pro_a_s
probers113514583probers
process11310403process
proctors12311513proctors
procure1138573procure
procures1239213procures
prolans9314273prolans
propers113619033propers
prosers94219643prosers
provers123817793provers
prowar114110943prowar_
racers84725433_racers
radars71314673_radars
rears54739653_r_ears
rebars84019833_rebars
recaps103615733_recaps
recurs83315803_recurs
ricers84120993_ricers
roads66523623_ro_ads
roams74919613_ro_ams
roans54926443_ro_ans
roar46328573_ro_ar_
rockers133916553_rockers
rocks114626413_roc_ks
rocs65533663_roc__s
rogers74517913_rogers
romans84620243_romans
ropers84325903_ropers
rosary92810353_rosary
rotary92411303_rotary
rotas54827723_rota_s
rotors64917953_rotors
rovers95423523_rovers
rowans95715343_rowans
rowers94924573_rowers
royals93711263_royals
scars75433533__scars
serovars1145233serovars
shofars1335833shofars
soars54732513_so_ars
socas74026183_soca_s
sofars94712783_sofars
sonars64818973_sonars
soucars938423soucars
sowars94318013_sowars
sowcars1236013sowcars
strokers123910903strokers
stroyers11388923stroyers
talars66021683t_alars
tarocs84615663taroc__s
tars46763953t___ars
tartars73313403tartars
tatars64619793t_atars
teacart91113193teacart
teacarts10116073teacarts
tears55436463t__ears
teopans939203teopans
thenars10248523thenars
throats104612193thro_ats
throwers14106033throwers
ticals83214713t_icals
tincals93610643tincals
tipcart1148833tipcart
tipcarts1244573tipcarts
tipcats1137103tipcats
toads65621073t_o_ads
tochers123413093t_ochers
todays10458103t_odays
toeas55726423t_oea_s
toecaps1135553toecaps
togas67823003t_oga_s
tokays13397773t_okays
tokers104818893t_okers
tolans64319273t_olans
tolar55524113t_olar_
tolas54532773t_ola_s
tomans85419133t_omans
tomcats11127773tomcats
toners64128003t_oners
toolbars1044743toolbars
toolers74416503toolers
tooters73818773tooters
topers85025323t_opers
torahs95115643t_orahs
toras55540373t_ora_s
torches123715443torches
torcs75123763torc__s
torpors939383torpors
torrs53923563t_o_rrs
tors46157383t_o__rs
tortas64918253torta_s
totals63115163t_otals
toters65026363t_oters
toucans937583toucans
tours55325893t_o_urs
toward10311063t_oward
towards1138783t_owards
towers94423673t_owers
toyers95516333t_oyers
tracer84820233tracer_
tracery12399793tracery
traces85329933trac_es
trackers143512853trackers
tracks124818843trac_ks
tractors10312573tractors
tracts85019073trac_ts
traders84316953traders
tramcar1135593tramcar_
trams75327673tr__ams
trans54933043tr__ans
trapans92812463trapans
traps75727483tr__aps
trass56226473tr__ass
trays85623433tr__ays
treads74817923tr_eads
treats64821693tr_eats
tremors93711233tremors
trepans92311593trepans
triacs83913223tr_iacs
triads74513533tr_iads
trials64319883tr_ials
tribals9610753tribals
triceps11267343triceps
trices84826333tric_es
trickers143812813trickers
tricks125319013tric_ks
triclads1146233triclads
tricorn937963tricorn
tricorns1036683tricorns
tricots9311563tricots
triers64321523tr_iers
trifocals1444043trifocals
trimers94615143trimers
trinary1039173trinary
tripart9311433tripart
troak95213573tro_a_k
trochaic1546943trochaic
trochaics1645063trochaics
trochal1288243trochal
troche113112513troc_he
trochee122613883trochee
trochees132510183trochees
trochil1258713trochil
trochils1388583trochils
trochlears1543143trochlears
trock114817603troc__k
trocked144312243trocked
troffers14125433troffers
trogons83410723trogons
trogs67022603tro__gs
troikas1135033troikas
troilus736413troilus
trois57226093tro__is
trokes104019263tro_kes
troland837543troland
trolands936423trolands
trollers83211213trollers
trolls64613943tro_lls
trompes114111623trompes
tromps104911703tro_mps
trona54118953trona__
trones65629283tro_nes
troopers10289443troopers
troops85712783tro_ops
tropes84824353tro_pes
tropicals1345613tropicals
tropics113610653tropics
tropins93116313tropins
troths95414153tro_ths
trots56629943tro__ts
trotters83310243trotters
trotyls10236033trotyls
troughs11698693troughs
trouncers1134803trouncers
troupers10359443troupers
troupes94112853troupes
trousers83910633trousers
trouts66116633tro_uts
trover95014663trover_
troves94719113tro_ves
trowels10358363trowels
trows88826183tro__ws
trowsers11428003trowsers
trowths1365023trowths
troys86418613tro__ys
truces84916333truc_es
truckers14279013truckers
trucks124711973truc_ks
tsars56717113t__sars
turbocar1243363turbocar_
tussars7359253tussars
twofers1364053twofers
tzars144914273t__zars
uproars986453upro_ars
vicars11712263_vicars
vocabs13336313_vocabs
vocals113811583_vocals

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.406440125.6
2DLD Change Limit1340272756.96619240.2
3Display Results2752750.0932957.0
 (SQL Overall)1786912757.46523937.2
 
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.