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

290 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
apos6543382(None) 
abos67734411abos
ados57633511ados
apes66047431apes
apo511142121apo_
apod78123181apod
apods86316341apods
apps86319691apps
avos77227011avos
capos94826071capos
epos66723731epos
aahs716428562aahs
aals49941142aals
aas310975392a_as
abas68642082abas
abo59045962abo_
abs59356072a_bs
abys97221882abys
aces67645092aces
acts66929862acts
adds67622452adds
adios65822862adios
ado49146872ado_
ads49755732a_ds
aeon45634612aeon
aeons57624652aeons
agas55938842agas
ages55844592ages
agios65919862agios
ago48845522ago_
agog68019002agog
agon56531882agon
agons66423782agons
ags47551662a_gs
ahis76135382ahis
ahoy101919182ahoy
ahs68644822a_hs
aids57846352aids
ails45654712ails
aims67738182aims
ains46158882ains
airs46447422airs
ais39083572a_is
aits46355532aits
alas46358122alas
albs68628572albs
ales47067102ales
alls46740922alls
alms65834922alms
aloe45540192aloe
aloes54933672aloes
alow75328592alow
alps65529242alps
als36663022a_ls
also46423442also
altos55822952altos
alts46639902alts
amas67746292amas
ambos95321242ambos
amis66445312amis
ammos94815822ammos
amok10217402amok
amoks11413552amoks
amps86230342amps
amus65529612amus
anas46649862anas
ands57833612ands
anes45255932anes
anis45746462anis
anoa45634472anoa
anoas57226492anoas
anon46134852anon
ants47243472ants
anus47131112anus
ape57251182ap_e
aped78538152aped
aper66336232aper
apers76629132apers
apex137220212apex
aphis105917132aphis
apish105116632apish
aport75432172aport
app76827602ap_p
appose10411992appose
apres75426402apres
apron7318832apron
aprons8316992aprons
apse67725382apse
apses76823912apses
apsis75718292apsis
apt57352542ap_t
arbs66834732arbs
arcs67834782arcs
ares45871022ares
arfs76029962arfs
arks85936872arks
arms66137492arms
arose55832082arose
ars37670932a_rs
arts49650262arts
arvos86015662arvos
as211083072a__s
askos95011772askos
asks85721212asks
aspis74618142aspis
asps65622092asps
ass37844062a_ss
ates45047922ates
atom67824522atom
atoms76817562atoms
atop66124752atop
auks85525262auks
autos56523322autos
aves76142602aves
avo68936232avo_
avow107816462avow
avows114910982avows
awes76037552awes
awls75926092awls
awns75324432awns
awol75620672awol
awols84713522awols
axes117337852axes
axis116127912axis
axon115524302axon
axons125517932axons
ayes76543512ayes
ays67050292a_ys
azo128233392azo_
azon135725052azon
azons146518252azons
baps86040842bap_s
bios66335312bios
boos67955032boos
bops86037982bops
bos57966812_bos
bros65635662bros
calos74431902calos
camos95927612camos
campos125217952campos
capes95441922capes
caphs124515372caphs
capo85829212capo_
capon95221872capon
capons104119502capons
caps87147892cap_s
coos67456492coos
cops86751372cops
cos510270392_cos
dados75522432dados
dagos76419442dagos
daps77239162dap_s
datos65222782datos
dos48062312_dos
duos56728132duos
egos55821652egos
eros45238452eros
expos1449202expos
fados95620732fados
fanos85926502fanos
faros85532022faros
fops96532682fops
gapes86030822gapes
gaps76042972gap_s
goos57644912goos
gos47155132_gos
halos85230252halos
haps96443462hap_s
hops97942632hops
hos68364192_hos
hypos1312014742hypos
japes146322822japes
jatos125116822jatos
kapas116021732kapas
kaphs144911502kaphs
kapok10448782kapok
kapoks11347262kapoks
kayos127714702kayos
kops107031292kops
kos76944822_kos
lapis76223152lapis
laps66848872lap_s
loos49051122loos
lops66043352lops
makos116518362makos
manos74933612manos
maps86141042map_s
mayos105521932mayos
mhos95517772mhos
moos66051302moos
mops85940132mops
mos57067122_mos
naos47429732naos
napas75924352napas
napes74828462napes
naps66238582nap_s
nos38859322_nos
onos46229002onos
oops65232672oops
opes65942612opes
ops56641252op_s
opts68124742opts
opus66420592opus
os211359882__os
pacs85842182pacs
pads76742952pads
pals66951352pals
pams85641762pams
pans65855722pans
papas94927492papas
paps86443452paps
pars67560792pars
pas58775742_pas
pass65239952pass
pats66460852pats
paws96038182paws
pays95940222pays
pepos96620082pepos
pes57259782_pes
pis56362032_pis
pod66351482_pod
pods76540152_pods
poh86740532_poh
poi57244662_poi
pois66539042_pois
pol56449382_pol
pols66044562_pols
pom78249912_pom
poms87037742_poms
pons65850602_pons
poo57757112_poo
poos65949112poos
pop76252252_pop
pops86340952_pops
pose66441732_pose
posh95427322_posh
post67953362_post
posy96028422_posy
pot58078432_pot
pots66452362_pots
pow87147282_pow
pows95537662_pows
pox126140692_pox
pros65742782pros
pus55547842_pus
rapes75740722rapes
raps66247732rap_s
ratos55528762ratos
repos74725792repos
rhos76319062rhos
sagos66123872sagos
sapor75119252sapor
sapors84118812sapors
saps65346372sap_s
saros55238062saros
sops65244562sops
sos37761602_sos
spas67036722spas
spot65540682spot
spots74424102spots
tacos77023552tacos
taos45541002taos
tapas74627712tapas
tapes75838602tapes
tapis75028862tapis
taps66050672tap_s
taros55640822taros
topos75726392topos
tops66248122tops
twos76718022twos
typos106015812typos
udos56619902udos
upas68322382upas
updos8389512updos
upo58925862upo_
upon65817582upon
ups55629052up_s
vapor104013092vapor
vapors113812692vapors
waps96642082wap_s
woos76238802woos
wops96634152wops
wos66953532_wos
yapok14468152yapok
yapoks15346782yapoks
yapon104613582yapon
yapons114411772yapons
yaps95933522yap_s
zaps156826892zap_s
zoos135828802zoos

Search took 3 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 Filter178691298720.1231452772.4
2DLD Change Limit298722901.79616632.5
3Display Results2902900.1102636.4
 (SQL Overall)1786912902.02988068.5
 
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.