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

381 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
koppas1440760(None) 
kappas144410361kappas
koppa13397291koppa_
poppas93710711poppas
compas125817062compas
coppras13327832coppras
copras103517152copras
cuppas12458592cuppas
dopas85019062do_pas
kalpas124112942kalpas
kapas116021732k_apas
kappa13469742kappa_
koalas104011662koalas
koas85635092ko__as
kolas94822232ko_las
kopeks1134602kopeks
kophs145010932ko_phs
kopjes1935362kopjes
koppie14277882koppie
koppies153210012koppies
kops107031292ko_p_s
koras95927112ko_ras
kormas124511232kormas
nappas105511612nappas
poppa8409892poppa_
alphas1139513alphas
anopias92412483anopias
aortas65417783aortas
appal95315223_appal
appals104812943_appals
apps86319693_app_s
arepas85515703arepas
boas66150833bo__as
boheas114013213boheas
bolas74733763bo_las
bopped134413403bopped
bopper123813833bopper
boppers133911923boppers
bops86037983bo_p_s
boras75938303bo_ras
boreas85421733boreas
botas75328783bo_tas
boylas113011723boylas
capias10318353capias
chuppas1644123chuppas
coalas87418963coalas
coapts104614013coapts
cobias104014993cobias
cobras104014193cobras
cocas95926573co_cas
cocoas104915743cocoas
codas84724243co_das
colas75436773co_las
colzas174010513colzas
comas95833003co_mas
commas124814573commas
compass13379563compass
compos124818803compos
comps115526053comp_s
compts125216653compts
congas94417033congas
coops96229643coop_s
coopts105814583coopts
copal95621783co_pal
copals105018943copals
copay126516313co_pay
copays134911273copays
copens106119963copens
copers104629843copers
copes97747103co_pes
copies104130303copies
copped135221253copped
copper124321893copper
copperas14308573copperas
coppers133519753coppers
coppra12306833coppra
copra98115463copra_
coprah133710603coprah
coprahs14338153coprahs
cops86751373co_p_s
copses104922473copses
copulas113811563copulas
corps95927043corp_s
corpus106015293corpus
cottas84615573cottas
coupes105022523coupes
coups95522473coup_s
cowpat13312033cowpat
cowpats1437713cowpats
cowpeas1437273cowpeas
coypus13389303coypus
cuppa11398523cuppa_
dipsas9359893dipsas
doblas93812293doblas
dobras94811913dobras
dogmas105011243dogmas
dolmas95213043dolmas
donas65926473do_nas
dongas84914613dongas
donnas75511323donnas
dopa77220903do_pa_
dopers95522483dopers
dopes84935043do_pes
dorps85419223dorp_s
doulas75114993doulas
doumas95314813doumas
douras75016723douras
ephas10311543_ephas
fopped144012673fopped
foppish1735103foppish
fops96532683fo_p_s
fossas94610703fossas
foveas1238623foveas
goas55239943go__as
goops86620963goop_s
gorps85316993gorp_s
grappas12357103grappas
hippos13408433hippos
hollas94616903hollas
hondas10313353hondas
hookas135312493hookas
hooplas1239193hooplas
hoops105621073hoop_s
hopers114222973hopers
hopes105835643ho_pes
hopped144318113hopped
hopper134218483hopper
hoppers143115143hoppers
hopple132910483hopple
hopples142810713hopples
hoppy154912353hopp_y
hops97942633ho_p_s
horas86333103ho_ras
hostas94515823hostas
hoyas115016163ho_yas
huppah1644183huppah
huppahs1743333huppahs
iotas54821113io_tas
jotas125717443jo_tas
kaas86531843k__aas
kakas85117343k_akas
kalpa114512193kalpa_
kalpac14428223kalpac
kalpacs15327133kalpacs
kalpak11437243kalpak
kalpaks12366163kalpaks
kanas95326913k_anas
kapa106021293k_apa_
kaphs144911503k_aphs
kapoks11347263kapoks
karmas123013733karmas
kas77058583k___as
kashas133311903kashas
katas95922093k_atas
kavas125919953k_avas
keas86337093k__eas
keeps116020283keep_s
kelps115116423kelp_s
kemps135012523kemp_s
kepis115313363k_epis
kepped15309533kepped
keppen14346563keppen
keps106027303k_ep_s
keypad1633823keypad
keypads1743343keypads
keypal1534893keypal
keypals1634353keypals
khaphs18394323khaphs
khedas1446313khedas
kiblas1239323kiblas
kinas95626913k_inas
kipped153114573kipped
kippen14299013kippen
kipper143414213kipper
kippers153211433kippers
kips106430513k_ip_s
kivas124614733k_ivas
knaps115511173knap_s
knopped16355443knopped
knops115911813knop_s
knosps12405013knosp_s
koa76737773ko__a_
koala95112213koala_
koan85425033ko__an
koans95818623ko_ans
kobos115616893ko_bos
kobs105831083ko__bs
koels94613903ko_els
kohls12437803ko_hls
koines10415733koines
kois85129403ko__is
kojis16468443ko_jis
kola85124963ko_la_
kolbasi1343693kolbasi
kolos94921213ko_los
kombus1435523kombus
konks84917113ko_nks
kooks85217263ko_oks
kop97440203ko_p__
kopeck1333423kopeck
kopecks1433073kopecks
kopek1037813ko_pek
koph135816543ko_p_h
kopiykas164803kopiykas
kopje1835273ko_pje
kora86431553ko_ra_
korai97018523ko_rai
korat94934433ko_rat
korats105416063korats
korma115913073korma_
kors85933013ko__rs
korunas1135443korunas
kos76944823ko___s
koss85224813ko__ss
kotos95717703ko_tos
kotows13446523kotows
koumis1237623koumis
koumys1543303koumys
kouros1039183kouros
kurtas10349883kurtas
kvas117015943k__vas
lampas106615953lampas
limpas105513083limpas
loofas9429833loofas
loops75723963loop_s
lopers84424143lopers
lopes76437343lo_pes
lopped114218623lopped
lopper103717203lopper
loppers113014103loppers
loppy125911663lopp_y
lops66043353lo_p_s
lotas55926303lo_tas
loumas84812333loumas
loupes84918053loupes
loups75319623loup_s
milpas101710273milpas
moas65545343mo__as
mochas13310663mochas
molas75132093mo_las
mommas94110653mommas
monas74732153mo_nas
moolas83615593moolas
mopeds11499663mopeds
mopers104220373mopers
mopes95134983mo_pes
mopped134114323mopped
mopper126215003mopper
moppers133412463moppers
moppet126915093moppet
moppets13307163moppets
mops85940133mo_p_s
moras76438773mo_ras
morphs13149433morphs
moxas145014393mo_xas
myopias14308153myopias
napas75924353_napas
nappa98511863nappa_
nappes104515623nappes
nipas77116673_nipas
nomas74726413no_mas
nonas55126653no_nas
nonpar8168993nonpar
nonpast939033nonpast
nopal75517103no_pal
nopals84914023nopals
norias65518203norias
novas85215363no_vas
obas65730933_o_bas
obias76116863_obias
ocas66729633_o_cas
odas57230263_o_das
ohias84415573_ohias
okapis1235393okapis
okas85225393_o_kas
okras94410973_okras
ollas54218283_ollas
oompah1334253oompah
oompahs1434263oompahs
oomphs1344723oomphs
oops65232673_oop_s
opah96218403_o_pah
opahs105411983_opahs
opal66923523_o_pal
opals75718353_opals
opens76118553_opens
operas8312453_operas
opes65942613_o_pes
oppose1039193_oppose
ops56641253_o_p_s
opts68124743_o_pts
opus66420593_o_pus
orcas75918623_orcas
ouphs104311273_ouphs
pampas124913993pampas
papas94927493_papas
pappus9408373pappus
paps86443453__paps
pas58775743___pas
peas65755063__peas
pias66542553__pias
polkas1239103polkas
pomps115316193pomp_s
poops94422413poop_s
popes95933813po_pes
poplar103611113poplar
poplars113910333poplars
popped104117813popped
popper93615963popper
poppers103414863poppers
poppet92717323poppet
poppets10338853poppets
poppies102816193poppies
popple92710983popple
popples103011873popples
poppy114813193popp_y
pops86340953po_p_s
pupas95219283_pupas
pyas96225703__pyas
qophs19507813qo_phs
repps95114343repp_s
romps94617543romp_s
ropers84325903ropers
ropes75940063ro_pes
rotas54827723ro_tas
roups75118903roup_s
salpas85116923salpas
sepias83616103sepias
shoppes143411393shoppes
soaps75120713soap_s
sobas74424253so_bas
socas74026183so_cas
sodas64123543so_das
sofas85320713so_fas
softas94410403softas
sojas124716393so_jas
somas76030373so_mas
sophs104916023so_phs
sopors85215203sopors
sopped114819903sopped
soppy125113523sopp_y
sops65244563so_p_s
soras55041013so_ras
soups75322943soup_s
soyas84520913so_yas
spas67036723__spas
stupas83910883stupas
tapas74627713_tapas
tepas76521683_tepas
toeas55726423to_eas
togas67823003to_gas
tolas54532773to_las
tongas74315523tongas
topaz16315323to_paz
topees85519703topees
topers85025323topers
topes76941763to_pes
tophes115218423tophes
tophs105220053to_phs
tophus115210363tophus
topics104714583topics
topis76025833to_pis
topmast1138123topmast
topos75726393to_pos
topped114617723topped
topper103817603topper
toppers113914603toppers
topple104411323topple
topples113111653topples
tops66248123to_p_s
toras55540373to_ras
tortas64918253tortas
typps12549303typp_s
upas68322383__upas
utopias9117723utopias
vodkas1443543vodkas
volvas12447993volvas
woops104917523woop_s
wops96634153wo_p_s
yogas96615603yo_gas
zoeas145815613zo_eas

Search took 5 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 Limit1127163814.65624208.8
3Display Results3813810.1233097.6
 (SQL Overall)1786913814.91936326.7
 
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.