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

352 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
carhop13361076(None) 
barhop13319641barhop
carhops14329701carhops
cartop104213561cartop
barhops14288112barhops
cachou13310612cachou
cahow135110942ca_how
carbo94923842carbo_
carbon104919042carbon
carbos105122262carbos
carboy134914182carboy
cardon94120852cardon
cargo85322072cargo_
cargos94619182cargos
carob95325222car_ob
carol75128612car_ol
carom95025562car_om
carp85139812car__p
carrom10513402carrom
carrot8423122carrot
carton84522662carton
cashoo11312252cashoo
chop116024922c__hop
crop87628632c_r_op
abhor10411063_abhor
achoo10315083_achoo
ahoy101919183_a_hoy
arbor74818113_arbor
archon11311753_archon
arco68331543_arco_
ardor64617863_ardor
argol65317263_argol
argon65520593_argon
argot67728643_argot
arhat8327093_arhat
armor75118053_armor
arrow83414883_arrow
arson55118833_arson
arvo76023433_arvo_
arvos86015663_arvos
atop66124753_a_top
barlow112911423barlow
baron78131243bar_on
barrow114512763barrow
baryon111211613baryon
bathos116215633bathos
bishop1336943bishop
cabob114616803ca_bob
cacao95420003cacao_
cacaos104616183cacaos
cache125122483cach_e
cached145419203cached
caches137926913caches
cachet134526413cachet
cachous14312563cachous
cahoot11416473cahoot
cahows14399123ca_hows
cajon144513903ca_jon
callow114714663callow
calo64936443ca_lo_
calos74431903ca_los
calthrop1563553calthrop
caltrop11267633caltrop
cameo95924993cameo_
cameos105818003cameos
camion103917193camion
camo85731753ca_mo_
camos95927613ca_mos
camp106336453ca__mp
camphol1645793camphol
camphor1636133camphor
campo115219763campo_
campos125217953campos
candor94516423candor
cannon84514443cannon
cannot83616773cannot
canoe75627253ca_noe
canon74725303ca_non
canopy1337723ca_nopy
canso75019403canso_
cansos84915383cansos
canto74931013canto_
canton85722993canton
cantor85621523cantor
cantos84826973cantos
canyon114512033canyon
cap76758983ca___p
caph116623293caph__
caphs124515373caph_s
capo85829213ca_po_
capon95221873ca_pon
capos94826073ca_pos
captor104914603captor
car59165563car___
carack142113173carack
caracol11310423caracol
carafe115416163carafe
carat75048793car_at
carate84734003carate
carats85929023carats
carb85143163car__b
carbons115418943carbons
carbora11310703carbora
carboys144711783carboys
carbs96031463car_bs
carcel105018673carcel
card710245873car__d
carded105424903carded
carder94524183carder
cardia9916373cardia
cardio9915673cardio
cardons104519933cardons
cardoon104813813cardoon
cards85137933car_ds
care66968373car__e
cared86050093car_ed
careen84119493careen
career85822243career
carer74942333car_er
carers85133953carers
cares77369183car_es
caress85720263caress
caret75360563car_et
carets85330773carets
carex144822293car_ex
carful11610973carful
cargoes104415223cargoes
carhopped1972763carhopped
caribe103416743caribe
caribou1156993caribou
caried94528693caried
caries85147623caries
carina84325323carina
caring95137993caring
carioca1139683carioca
cariole9818343cariole
carious93320283carious
cark105539273car__k
carked134024823carked
carks115534213car_ks
carl65144783car__l
carle74535703car_le
carles85435083carles
carlin84421823carlin
carload1039783carload
carls77037423car_ls
carman103920743carman
carmen104019343carmen
carn66245433car__n
carnal83919203carnal
carnet84732873carnet
carney115315703carney
carnie84421093carnie
carns75937563car_ns
carny105822923car_ny
carobs104818103carobs
caroch13911763caroch
caroli85918233caroli
carols85124983carols
caroms105619573caroms
carpal103716253carpal
carped115923763carped
carpel105418473carpel
carper104923633carper
carpet104530093carpet
carpi94319393car_pi
carpool1139223carpool
carport11316033carport
carps96932253car_ps
carpus105514303carpus
carr65434703car__r
carrel84718633carrel
carrion9312673carrion
carroch1437093carroch
carroms11512403carroms
carrots9714623carrots
carroty1248943carroty
carrs75730853car_rs
carry105823783car_ry
carryon1237033carryon
cars67364763car__s
carse74934333car_se
carses85233653carses
cart66570343car__t
carte75940423car_te
carted98631443carted
cartel85022533cartel
carter84932273carter
cartes86239473cartes
cartons94122473cartons
cartoon94114463cartoon
carts78946293car_ts
carve106227753car_ve
carved124320853carved
carvel114817573carvel
carven114716663carven
carver114420143carver
carves115128453carves
cash96636283cash__
cashaw14439793cashaw
cashbox2143453cashbox
cashed125124353cashed
cashes114729883cashes
cashew144311453cashew
cashoos12310793cashoos
castor84418533castor
catchup1644783catchup
cathode1338993cathode
cation83925503cation
catnap1098383catnap
catnip1097963catnip
catsup1036433catsup
cero66329453cer_o_
ceros74726073cer_os
chap114928493c__hap
chariot12316213chariot
charpoy1735713charpoy
charro114212953charro_
charros124312143charros
chip116726423c__hip
chomp144815663c__homp
chon96627793c__hon
chops125019873c__hops
chow125820993c__how
clarion9311663clarion
claro75018693clar_o_
claros84015113clar_os
clop86929893c__lop
coho97524493c_oho_
cohog117813043c_ohog
cohos105921853c_ohos
collop107312313collop
coop87238653c__oop
cop711162373c___op
cordon95017293cordon
cramp115120693c_ramp
crap85731843c_r_ap
craton84517193craton
crayon114110003crayon
creep95218103c_reep
crimp115615803c_rimp
crisp95014623c_risp
croc85723733c_r_oc
crook115217573c_rook
croon75522783c_roon
crops96125233c_r_ops
croup95616783c_roup
crow96428133c_r_ow
crump115616423c_rump
cruor7310443c_ruor
curio74221203curio_
curios83218333curios
cursor84110293cursor
czardom2144183czardom
droop85814823_droop
drop75324403_dr_op
eardrop1065223eardrop
earlap837183earlap
earshot10410823earshot
faro76136923far_o_
faros85532023far_os
farrow12309973farrow
fathom1437473fathom
gallop93311383gallop
galop84716213ga_lop
garcon92912483garcon
garron73113493garron
harbor11410723harbor
hardtop1345053hardtop
harlot94422803harlot
harp96134283har__p
harrow122610773harrow
hop87554593___hop
jalop144212603ja_lop
jargon1448823jargon
karoo92519583kar_oo
karoos102415803karoos
karroo10410013karroo
laptop1076813laptop
lardon74415063lardon
largo65319783largo_
largos74815063largos
larrup835713larrup
macho126120153macho_
machos135217493machos
mahoe10315573ma_hoe
markhor1635463markhor
markup1436903markup
marmot10318743marmot
maroon83118203maroon
marron83717543marron
marrow112812603marrow
mayhap1635233mayhap
maypop1565143maypop
nacho105414383nacho_
nachos115014183nachos
narco76718243narco_
narcos86714203narcos
narrow9269143narrow
orlop7410903_orlop
pardon94618733pardon
pareo74632603pareo_
pareos87023773pareos
pargo86723723pargo_
pargos95719043pargos
parlor8312673parlor
parol74826273par_ol
parrot8320663parrot
parson83817903parson
parton84720993parton
parvo107719183parvo_
parvos116614753parvos
pathos115516693pathos
preop94715873_preop
prop85932813_pr_op
ragtop936683ragtop
rho65924833__rho_
rhos76319063__rhos
saloop84212583saloop
sannop837373sannop
sargo65424413sargo_
sargos74318273sargos
sarod65325873sar_od
saros55238063sar_os
sartor6313873sartor
scallop11237643scallop
scarp95724103scar__p
scroop10299773scroop
shop95629833__shop
strop77422243str_op
tardo65321103tardo_
taro46846913tar_o_
taroc75721643tar_oc
tarok97921073tar_ok
taros55640823tar_os
tarot55943933tar_ot
tarp66936413tar__p
tarpon82812803tarpon
teashop1246083teashop
troop76417533_troop
trop66833303_tr_op
varoom11411413varoom
wahoo112413083wa_hoo
wallop113310293wallop
warmup1335343warmup
warp95635003war__p
warship1547833warship
warthog1444533warthog
washup1435323washup
whop125520923__whop
yahoo112911543ya_hoo
yarrow12287933yarrow

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.1431249587.4
2DLD Change Limit1127163526.42017557.0
3Display Results3523520.1103200.0
 (SQL Overall)1786913526.67326778.2
 
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.