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

357 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
okapi113661(None) 
okapis1235391okapis
kadi96224842_kadi
kaki76520922_kaki
kami105823652_kami
kapa106021302_kapa
kaph135815762_kaph
kepi105315642_kepi
oka76926802oka__
okas85225392oka_s
okay115917662oka_y
okays12609442okays
abaci94718843abaci
acari75020283acari
adapt81218553adapt
agapai9456863agapai
agape85614843agape
ahi68040233__ahi
ai211288403__a_i
alkali10127563alkali
ami56646813__ami
ani37751183__ani
ape57251183__ape
apo511142123__apo
app76827603__app
apt57352543__apt
atap66722453atap_
ataps76414833ataps
bani65334963_bani
bap76455843_bap_
baps86040843_baps
biali73419073biali
bonaci10310963bonaci
bravi104715753bravi
cadi75732193_cadi
campi116217783campi
cap76758983_cap_
cape87242783_cape
caph116623293_caph
capiz18514563_capiz
capo85829213_capo
caps87147893_caps
carpi94319393carpi
chai95929903cha_i
chap114928493chap_
chape125221143chape
chaps125326063chaps
chapt125827643chapt
clap86429043clap_
claps95626183claps
clapt98027173clapt
clavi104912923clavi
coapt96131533coapt
coati75624643coati
crap85731843crap_
crape96128443crape
craps95328643craps
dap66652453_dap_
daps77239163_daps
diapir9357113diapir
drape85319633drape
elapid939543elapid
etape74413703etape
flap96128703flap_
flaps105621383flaps
flokati1443483flokati
frap95925813frap_
fraps105620553fraps
gadi66329733_gadi
gap67055613_gap_
gape75134513_gape
gaps76042973_gaps
gapy106320913_gapy
ghazi1837443ghazi
grape84824663grape
graph115315613graph
grapy115416433grapy
haji148520193_haji
hap87360053_hap_
haps96443463_haps
heap96432893heap_
heaps105223223heaps
heapy135914983heapy
ikat87626653ika_t
ikats95311153ikats
impi85415793_impi
inapt73522693inapt
jape134923423_jape
ka69145093_ka__
kaas86531853_kaas
kab97145863_ka_b
kabs107130853_kabs
kadis105921073_kadis
kae76744553_ka_e
kaes85734073_kaes
kaf106845523_ka_f
kafir12488903_kafir
kafs116423753_kafs
kagu95418123_kagu
kaif116933943_kaif
kail85131503_kail
kain85334303_kain
kaka76518693_kaka
kakapo1143853kakapo
kakis86116843_kakis
kale86533763_kale
kalif125021363_kalif
kalpa114512193_kalpa
kame105728243_kame
kamik105011553_kamik
kana85928543_kana
kane85133983_kane
kanji1647453_kanji
kaon87521033_kaon
kapas116021733_kapas
kaphs144911503_kaphs
kapok10448783_kapok
kappa13469743_kappa
kaput11717063_kaput
karn86129423_karn
kart86750813_kart
kas77058593_ka_s
kat77468303_ka_t
kata85626033_kata
kats85944343_kats
kauri93811853_kauri
kava115819713_kava
kay106745553_ka_y
kayo116417563_kayo
kays116032203_kays
kep96437213_kep_
kepis115313363_kepis
keps106027313_keps
kept106232953_kept
khadi1367613khadi
khaki1157643khaki
khaph17395963khaph
khi106318313_k_hi
ki67537973_k__i
kip97042153_kip_
kips106430533_kips
kiwi113211813_kiwi
knap105815413knap_
knaps115511173knaps
koa76737783koa__
koala95112213koala
koan85425043koa_n
koans95818623koans
koas85635103koa_s
koi77534763_k_oi
koji155611133_koji
kop97440213_kop_
koph135816553_koph
koppa13397293koppa
koppie14277883koppie
kops107031303_kops
korai97018523korai
kufi11910663_kufi
laari54415713laari
lap58565273_lap_
lapin75222923_lapin
lapis76223153_lapis
laps66848873_laps
lari45839153_lari
lati46438273_lati
leap66032683leap_
leaps75522933leaps
leapt75027473leapt
magi76329533_magi
map77255123_map_
maps86141053_maps
maxi137023563_maxi
naoi46024633_naoi
nap56753203_nap_
napa66927263_napa
nape65230803_nape
naps66238583_naps
nazi136219873_nazi
neap66927013neap_
neaps75618323neaps
oaf65952883o_a_f
oafs76425263o_afs
oak76238653o_a_k
oaken95814383oaken
oaks86527903o_aks
oakum1177313oakum
oaky116419953o_aky
oar37057953o_a_r
oars46846033o_ars
oasis56422553o_asis
oast47156323o_ast
oat39888263o_a_t
oath76132153o_ath
oats46554213o_ats
oba57531553oba__
obas65730933oba_s
obeli73711933obeli
obi57127733o__bi
oboli73712873oboli
oca56731733oca__
ocas66729633oca_s
octopi1036533octopi
oculi72010793oculi
oda48133053oda__
odah87018933oda_h
odahs95610083odahs
odas57230263oda_s
ofay106416103ofa_y
ofays11488923ofays
ogam75120033oga_m
ogams84112683ogams
oi29061493o___i
okayed1434253okayed
okaying1534833okaying
oke75839483ok__e
okeh114615323ok_eh
okehs12477463okehs
okes84936343ok_es
okra86413573ok_ra
okras94410973okras
omasa749483omasa
onagri754963onagri
oomph1236973oomph
oops65232673o_ops
oorali6311263oorali
op45850163o__p_
opah96218403opa_h
opahs105411983opahs
opal66923523opa_l
opals75718353opals
ope56845243o__pe
ops56641253o__ps
opt57545543o__pt
ora37250833ora__
orach105219233orach
orad56031693ora_d
oral47638123ora_l
orals55826483orals
orang65119943orang
orate55133303orate
oribi7311093oribi
orpin73415533o_rpin
osar46820953osa_r
ouph95618373o_uph
ourari63413543ourari
ova66823793ova__
oval77119523ova_l
ovals85413393ovals
ovary1149113ovary
ovate84214393ovate
ovoli8358283ovoli
oxalic1537093oxalic
oxalis1339223oxalis
oxlip1456883oxlip
ozalid1696683ozalid
padi76331793_padi
palpi95414553palpi
pap76758403_pap_
papa85827143_papa
pappi84810893pappi
paps86443453_paps
pi48145373___pi
polypi13458593polypi
priapi1037923priapi
qadi145621113_qadi
quai134420393qua_i
quasi144015023quasi
ragi56032283_ragi
rai37658223_ra_i
raki87127833_raki
rami66034093_rami
rani46640113_rani
rap56261963_rap_
rape65041633_rape
rapid86422033_rapid
raps66247733_raps
rapt67245313_rapt
reap65934743reap_
reaps75626193reaps
romaji1534893romaji
sadi55834653_sadi
saki85628483_saki
sap56463233_sap_
sapid84720933_sapid
saps65346373_saps
sari45444043_sari
sati45539333_sati
scampi12469103scampi
scape96921843scape
shape105125113shape
ska76925863ska__
skag96321513ska_g
skags104316073skags
skald104210173skald
skank84415583skank
skas85325713ska_s
skat87037903ska_t
skate94721553skate
skats94621543skats
skep105219353skep_
skeps115614253skeps
ski74925703sk__i
skip105421763skip_
skips115616613skips
slap66434043slap_
slaps76025713slaps
snap65727033snap_
snaps74719563snaps
soap65831133soap_
soaps75120713soaps
soapy106114783soapy
souari6311383souari
spahi10311143spahi
staph104314653staph
swami105614523swami
swap95925433swap_
swaps104819203swaps
tali46837163_tali
tap57663883_tap_
tapa65129153_tapa
tape64538153_tape
tapir75917063_tapir
tapis75028863_tapis
taps66050683_taps
taxi117124763_taxi
tempi94912203tempi
tipi69924443_tipi
tokay125513053toka_y
tokays13397773tokays
topi67830393_topi
tragi64717173tragi
trap67532803trap_
traps75727483traps
trapt76433393trapt
tsadi6379913tsadi
uakari1046863uakari
ukase9428493ukase
umami939883umami
unai44824783una_i
unapt710421593unapt
uraei53016083uraei
urari54619963urari
vagi86719363_vagi
vapid115614283_vapid
wadi86228183_wadi
wap86553373_wap_
waps96642083_waps
whap125119643whap_
whaps135115163whaps
wrap96821973wrap_
wraps105617153wraps
wrapt105123183wrapt
yagi86922243_yagi
yap85949823_yap_
yaps95933523_yaps
zap145840693_zap_
zaps156826893_zaps

Search took 4 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 Filter178691836670.390458182.1
2DLD Change Limit836673573.42024464.0
3Display Results3573570.0963718.8
 (SQL Overall)1786913573.90645747.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.