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 “tarps” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

289 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
tarps7652711(None) 
carps96932251carps
harps105926861harps
tamps95524081tamps
taps66050671ta_ps
tares57456561tares
tarns56433951tarns
taros55640821taros
tarp66936411tarp_
tars46763951tar_s
tarts57242021tarts
traps75727481traps
turps74918731turps
warps107126421warps
alps65529242_alps
amps86230342_amps
apps86319692_apps
arbs66834732_arbs
arcs67834782_arcs
ares45871022_ares
arfs76029962_arfs
arks85936872_arks
arms66137492_arms
ars37670932_ar_s
arts49650262_arts
asps65622092_asps
ataps76414832ataps
baps86040842ba_ps
barbs95928192barbs
bards87139642bards
bares75457132bares
barfs104826002barfs
barks115735812barks
barms96128462barms
barns76335142barns
bars66564092bar_s
burps94220172burps
camps116330262camps
caps87147892ca_ps
carbs96031462carbs
cards85137932cards
cares77369182cares
carks115534212carks
carls77037422carls
carns75937562carns
carp85139812carp_
carpi94319392carpi
carpus105514302carpus
carrs75730852carrs
cars67364762car_s
carts78946292carts
corps95927042corps
craps95328642craps
damps105220412damps
daps77239162da_ps
darbs85323262darbs
dares66146702dares
darks106727872darks
darns66927892darns
darts67635732darts
dorps85419222dorps
earls56127512earls
earns55927562earns
ears46356592ear_s
fards96629842fards
fares85852872fares
farls85731112farls
farms106324952farms
faros85532022faros
farts88336842farts
fraps105620552fraps
gamps105323712gamps
gaps76042972ga_ps
garbs86321412garbs
gars55750742gar_s
gasps85415482gasps
gawps115911012gawps
gorps85316992gorps
haps96443462ha_ps
hards96435652hards
hares86255542hares
harks126333432harks
harls85634502harls
harms106829012harms
harp96134282harp_
harpy136418202harpy
harts88441592harts
hasps105114642hasps
jarls126120962jarls
jars117338352jar_s
jaups144810532jaups
karns96624142karns
karts97630112karts
lamps95624832lamps
laps66848872la_ps
lards65331862lards
lares54852632lares
laris54737462laris
larks95227812larks
lars46956572lar_s
maps86141042ma_ps
maras75443282maras
marcs95726622marcs
mares76457632mares
marks115933482marks
marls75535162marls
mars66261862mar_s
marts77442232marts
naps66238582na_ps
narcs76122022narcs
nards65928462nards
nares55544152nares
naris55735292naris
narks96026032narks
oars46846032oar_s
palps94719562palps
paps86443452pa_ps
paras76143042paras
pards85634332pards
pares77164482pares
paris75145942paris
parks116134462parks
parrs75928672parrs
pars67560792par_s
parts77743372parts
perps95521482perps
ramps96224632ramps
raps66247732ra_ps
rares55247442rares
rasps74316662rasps
salps74423242salps
samps96124672samps
saps65346372sa_ps
sards64736182sards
saris54544952saris
sarks96632462sarks
saros55238062saros
scarps104718602scarps
sharps115516082sharps
stamps105614022stamps
stares66038752stares
stars55836572star_s
starts65423122starts
stirps85011812stirps
straps87721782straps
tabes76033922tabes
tabs66842982ta_bs
tabus74820922tabus
taces76237802taces
tachs105820932tachs
tacks115430132tacks
tacos77023552tacos
tacts76524122tacts
tads57143942ta_ds
taels56822072taels
tags55545232ta_gs
tahrs85412332tahrs
tails55634192tails
tains54936322tains
tajes124920692tajes
takas95520682takas
takes94437792takes
talas55935892talas
talcs74817182talcs
tales55451372tales
talks94322692talks
talls55133432talls
talus55423262talus
tames75242012tames
tamis76728722tamis
tamp86133002tamp_
tams67247932ta_ms
tangs65028342tangs
tanks94624732tanks
tans46154812ta_ns
taos45541002ta_os
tap57663872ta_p_
tapa65129142ta_pa
tapas74627712tapas
tape64538142ta_pe
tapes75838602tapes
tapis75028862tapis
tar37570692tar__
tardo65321102tardo
tardy94720462tardy
tare45957622tar_e
tared69340052tared
targe65227092targe
targes74524592targes
tarn46842722tar_n
taro46846912tar_o
taroc75721642taroc
tarocs84615662tarocs
tarok97921072tarok
taroks106115282taroks
tarot55943932tarot
tarots66422992tarots
tarpan82814292tarpan
tarpans92513532tarpans
tarpon82812802tarpon
tarpons92612202tarpons
tarre55825632tarre
tarres64723042tarres
tarry85422512tarry
tarsi55222172tarsi
tarsus6310512tarsus
tart47566182tar_t
tarty86328182tarty
tas38477102ta__s
tasks94917582tasks
tass45640572ta_ss
tates55444982tates
tats46858132ta_ts
taupe7314162taupe
taupes8212672taupes
taus46342732ta_us
tauts56125512tauts
tavs75630972ta_vs
taws75641592ta_ws
taxes124730822taxes
taxis126821972taxis
taxus125512482taxus
tears55436462tear_s
temps95417132temps
terms75523472terms
terns55226872terns
tharms115712242tharms
thorps113610892thorps
thrips11299012thrips
tiaras6314532tiaras
tips66436762t_ips
tires55437492tires
tirls54519802tirls
tiros54524892tiros
tops66248122t_ops
toras55540372toras
torcs75123762torcs
tores55352672tores
toros54336192toros
torrs53923562torrs
tors46157382tor_s
torts56138122torts
torus54329762torus
tramps105114452tramps
trams75327672trams
trans54933042trans
trap67532802trap_
trapes85024462trapes
trapt76433392trapt
trass56226472trass
trays85623432trays
tres46542902t_res
trips74923362trips
tsars56717102tsar_s
tumps95420792tumps
tups65628762t_ups
turds65021692turds
turfs84620442turfs
turks95320822turks
turns55623232turns
twerps11345152twerps
twirps11415012twirps
typps12549302typps
tyres84725232tyres
tyros85118592tyros
tzars144914272tzar_s
urps66920472_urps
vamps125415482vamps
varas86028192varas
vars75742072var_s
varus85921182varus
waps96642082wa_ps
wards97734402wards
wares88250582wares
warks127932402warks
warms107726852warms
warns87231002warns
warp95635002warp_
wars78659802war_s
warts814840402warts
wasps106714692wasps
wraps105617152wraps
yaps95933522ya_ps
yards95324612yards
yarns85621792yarns
yaups105910742yaups
yawps13628792yawps
zaps156826892za_ps
zarfs174713622zarfs

Search took 2 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 Filter178691538000.0931921408.6
2DLD Change Limit538002891.65632487.9
3Display Results2892890.0803612.5
 (SQL Overall)1786912891.82997698.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.