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

401 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
yapoks1534678(None) 
kapoks11347261kapoks
yapocks18354721yapocks
yapok14468151yapok_
yapons114411771yapons
amoks11413552_amoks
apods86316342_apods
apos65433822_apo_s
capons104119502capons
capos94826072capo_s
kapok10448782kapok_
sapors84118812sapors
taroks106115282taroks
vapors113812692vapors
yacks144419812ya_cks
yahoos12209242yahoos
yaks116025202ya__ks
yanks125316572ya_nks
yapock17365382yapock
yapon104613582yapo_n
yaps95933522yap__s
yaupons12345682yaupons
yoks116223742y__oks
yupons11398352yupons
abos67734413_abo_s
ados57633513_ado_s
aeons57624653_aeons
agons66423783_agons
aloes54933673_aloes
amok10217403_amok_
anoas57226493_anoas
apers76629133_apers
apes66047433_ap_es
aphis105917133_aphis
apo511142123_apo__
apod78123183_apo_d
aport75432173_aport
apps86319693_ap_ps
apres75426403_apres
aprons8316993_aprons
apses76823913_apses
apsis75718293_apsis
araks94820883_araks
arks85936873_a_rks
askos95011773_askos
asks85721213_a_sks
atoms76817563_atoms
auks85525263_a_uks
avos77227013_avo_s
avows114910983_avows
awoke124912003_awoke
awols84713523_awols
axons125517933_axons
azons146518253_azons
baboos103517013baboos
backs135729623ba_cks
bacons104917583bacons
balks114926293ba_lks
banks115527903ba_nks
baps86040843bap__s
barks115735813ba_rks
barons85025383barons
basks115621763ba_sks
batiks1239373batiks
batons85519423batons
baulks12429373baulks
bayous11411143bayous
bazoos173212623bazoos
bipods11408593bipods
books115729713_books
brooks125813883brooks
cabobs124311893cabobs
cahows14399123cahows
calks115421603ca_lks
calos74431903calo_s
camos95927613camo_s
campos125217953campo_s
canoes84725883canoes
canons85522063canons
capers105428133capers
capes95441923cap_es
caphs124515373cap_hs
capias10318353capias
capo85829213capo__
capon95221873capo_n
capote10315733capote
capotes11314643capotes
capris10415073capris
caprocks1835943caprocks
caps87147893cap__s
captors113914983captors
carks115534213ca_rks
carobs104818103carobs
carols85124983carols
caroms105619573caroms
casks115720063ca_sks
caulks125611863caulks
chooks155312793chooks
cooks115429143_cooks
crooks124914413crooks
dadoes85616533dadoes
dados75522433dado_s
dagoes85714603dagoes
dagos76419443dago_s
daks97130603da__ks
daps77239163dap__s
darks106727873da_rks
datos65222783dato_s
dawks135213493da_wks
depots94716343depots
ebooks12358333ebooks
epos66723733_epo_s
expos1449203expo_s
fados95620733fado_s
fagots1039963fagots
famous11412393famous
fanons96115213fanons
fanos85926503fano_s
faros85532023faro_s
favors124211403favors
galops94712613galops
ganofs104010293ganofs
gaols66717573ga_ols
gapers94520463gapers
gapes86030823gap_es
gaposis1038423gaposis
gaps76042973gap__s
gators74115823gators
gavots1038103gavots
gawks136811633ga_wks
gazoos163010223gazoos
gipons9389603gipons
gooks105422883_gooks
groks105716123_groks
haceks15447863haceks
hacks144928713ha_cks
haiks125120933ha_iks
haloes94623863haloes
halons95720713halons
halos85230253halo_s
hanks126226863ha_nks
haps96443463hap__s
harks126333433ha_rks
havocs1435653havocs
hawks155415703ha_wks
hooks125027123_hooks
hypos1312014743hypo_s
jabots1538883jabots
jacks185219833ja_cks
jalops15329593jalops
japans1539823japans
japers154616173japers
japes146322823jap_es
jatos125116823jato_s
jauks165412463ja_uks
jupons15377803jupons
kabobs14439303kabobs
kaiaks937043kaiaks
kalpaks12366163kalpaks
kamiks11387913kamiks
kaons95014853ka_ons
kapas116021733kap_as
kaphs144911503kap_hs
kappas144410363kappas
karoos102415803karoos
kaross101910013kaross
kayaks1236333kayaks
kayoes134710823kayoes
kayos127714703kayo_s
kazoos19259113kazoos
kooks85217263_kooks
kopeks1134603kopeks
kyacks14416063kya_cks
kyaks11459163kya__ks
labors84016403labors
lacks116129203la_cks
lapdogs1134073lapdogs
lapels83712043lapels
lapins84520683lapins
lapis76223153lap_is
laps66848873lap__s
lapses85217693lapses
lapsus8437273lapsus
laptops1166603laptops
larks95227813la_rks
looks95124863_looks
lupous849433lupous
macks135127603ma_cks
macons104017243macons
magots9312363magots
mahoes11313103mahoes
majors154511093majors
makos116518363mako_s
manors84420883manors
manos74933613mano_s
maples104819423maples
maps86141043map__s
marks115933483ma_rks
masks115320533ma_sks
masons83916513masons
mayors115714193mayors
mayos105521933mayo_s
maypops16104453maypops
mopoke1436633mopoke
mopokes1536693mopokes
nabobs10388213nabobs
naos47429733na_o_s
napas75924353nap_as
napes74828463nap_es
nappas105511613nappas
nappes104515623nappes
naps66238583nap__s
narks96026033na_rks
nooks95420393_nooks
oaks86527903oa__ks
packs135528933pa_cks
padouks1434863padouks
paeons83915523paeons
pagods105310193pagods
paiks114719853pa_iks
papas94927493pap_as
papaws13419113papaws
papers105125323papers
papoose1147513papoose
pappous1057463pappous
pappus9408373pappus
paps86443453pap__s
parks116134463pa_rks
parols84722613parols
parous84024163parous
patois84319363patois
payors114312643payors
pepos96620083pepo_s
pocks135022963__pocks
pods76540153__pods
pois66539043__pois
poke105335363__poke
pokes116133013__pokes
poky135922153__poky
pols66044563__pols
poms87037743__poms
pons65850603__pons
poos65949113__poos
pops86340953__pops
porks115124143__porks
pots66452363__pots
pows95537663__pows
racks115028853ra_cks
racons84319343racons
radons74118523radons
ramous8417103ramous
ranks95225733ra_nks
rapers84327183rapers
rapes75740723rap_es
raphes115117453raphes
raphis114014323raphis
rapids94913893rapids
raps66247733rap__s
raptors94213353raptors
ratos55528763rato_s
rayons94113343rayons
razors154711653razors
repos74725793repo_s
repots85621003repots
rooks95325043_rooks
sabots8314693sabots
sacks114228873sa_cks
sagos66123873sago_s
sajous13310583sajous
salols64017873salols
salons63823683salons
sameks12409323sameks
sapor75119253sapo_r
sapota8310203sapota
sapotas939603sapotas
sapote8314353sapote
sapotes9313933sapotes
sapour83812373sapour
sapours93610613sapours
saps65346373sap__s
sarks96632463sa_rks
sarods74918573sarods
saros55238063saro_s
savors95616103savors
savoys12427893savoys
sepoys1138473sepoys
shooks134515623shooks
snooks104412823snooks
sooks94425453_sooks
sopors85215193sopors
spanks124514123spanks
sparks124616363sparks
spiks114117473_spiks
spoke114818663_spoke
spokes124417213_spokes
spooks124312933spooks
spots74424103_spots
stooks105115373stooks
taboos83815423taboos
tabors84517093tabors
tacks115430133ta_cks
tacos77023553taco_s
talks94322693ta_lks
talons64019423talons
taluks10418283taluks
tampons112711553tampons
tanks94624733ta_nks
taos45541003ta_o_s
tapas74627713tap_as
tapers84025813tapers
tapes75838603tap_es
tapirs84113173tapirs
tapis75028863tap_is
taps66050673tap__s
tarocs84615663tarocs
tarok97921073tarok_
taros55640823taro_s
tarots66422993tarots
tarpons92612203tarpons
tasks94917583ta_sks
tauons63412673tauons
taxols13328633taxols
taxons134211503taxons
teapots939053teapots
teapoys1235963teapoys
tepoys1137543tepoys
topos75726393topo_s
tupiks1235493tupiks
typos106015813typo_s
valors93413773valors
vapor104013093vapo_r
vapory14398763vapory
vapour11378873vapour
vapours12277453vapours
wackos155210993wackos
wacks146626283wa_cks
wagons103911213wagons
wahoos122310593wahoos
walks126218503wa_lks
wanks126124483wa_nks
waps96642083wap__s
warks127932403wa_rks
wauks125515163wa_uks
wazoos18288553wazoos
weapons12278603weapons
woks116224903__woks
yachts1437023yachts
yack135425973ya_ck_
yaffs145311123ya_ffs
yagers105114533yagers
yagis95416573ya_gis
yags86632293ya__gs
yahoo112911543yaho_o
yairds10448023yairds
yak107038563ya__k_
yamens114010823yamens
yams95330733ya__ms
yamuns11336513yamuns
yangs95618693ya_ngs
yank115423663ya_nk_
yap85949823yap___
yapped144415143yapped
yapper133714513yapper
yappers144012253yappers
yards95324613ya_rds
yarns85621793ya_rns
yarrows13277853yarrows
yasmaks1633653yasmaks
yauds95013223ya_uds
yaupers12337663yaupers
yaupon11345493yaupo_n
yaups105910743ya_ups
yawls114613603ya_wls
yawns114213273ya_wns
yawpers15346853yawpers
yawps13628793ya_wps
yaws105531213ya__ws
yays105728913ya__ys
yelks126413623y_elks
yeps95924403yep__s
yerks125416563y_erks
yeuks125110093y_euks
yipes106017843yip_es
yips95226693yip__s
yobs96028083y__obs
yocks144418373y_ocks
yods86531183y__ods
yoicks15375933yoicks
yok107335243y__ok_
yoke115626393y__oke
yokes125223023y__okes
yolks125412773y_olks
youpons12265983youpons
yous76230653y__ous
yows106433123y__ows
yucks144717193y_ucks
yuks116418023y__uks
yupon10469483yupo_n
yups96121603yup__s
zaps156826893zap__s
zooks184716943_zooks

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127164017.26615512.8
3Display Results4014010.2661507.5
 (SQL Overall)1786914017.67223291.3
 
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.