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

246 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
asps6562209(None) 
alps65529241alps
amps86230341amps
apps86319691apps
asks85721211asks
asp57235341asp_
aspis74618141aspis
ass37844061as_s
gasps85415481gasps
hasps105114641hasps
rasps74316661rasps
saps65346371saps
wasps106714691wasps
aahs716428562aahs
aals49941142aals
aas310975392a_as
abas68642082abas
abos67734412abos
abs59356072a_bs
abys97221882abys
aces67645092aces
acts66929862acts
adds67622452adds
ados57633512ados
ads49755732a_ds
agas55938842agas
ages55844592ages
ags47551662a_gs
ahis76135382ahis
ahs68644822a_hs
aids57846352aids
ails45654712ails
aims67738182aims
ains46158882ains
airs46447422airs
ais39083572a_is
aits46355532aits
alas46358122alas
albs68628572albs
ales47067102ales
alls46740922alls
alms65834922alms
alp56641132alp_
als36663022a_ls
alts46639902alts
amas67746292amas
amis66445312amis
amp77541022amp_
amus65529612amus
anas46649862anas
ands57833612ands
anes45255932anes
anis45746462anis
ants47243472ants
anus47131112anus
ape57251182a_pe
apes66047432apes
apo511142122a_po
apos65433822apos
app76827602a_pp
apse67725382apse
apses76823912apses
apsis75718292apsis
apt57352542a_pt
arbs66834732arbs
arcs67834782arcs
ares45871022ares
arfs76029962arfs
arks85936872arks
arms66137492arms
ars37670932a_rs
arses55733872arses
arsis55722422arsis
arts49650262arts
as211083072a__s
asci66519142asci
ascus75013582ascus
asea46327182asea
ash67944602as_h
ashes86230612ashes
ashy107717352ashy
ask77130702as_k
askos95011772askos
aspen75216092aspen
aspens85013352aspens
asper75520432asper
aspers86220312aspers
aspic95114732aspic
aspics104211562aspics
aspish114810332aspish
asses55629282asses
ataps76414832ataps
ates45047922ates
auks85525262auks
aves76142602aves
avos77227012avos
awes76037552awes
awls75926092awls
awns75324432awns
axes117337852axes
axis116127912axis
ayes76543512ayes
ays67050292a_ys
baps86040842baps
bases75644352bases
basis75429862basis
basks115621762basks
bass66146782bas_s
basts75936932basts
bops86037982bops
camps116330262camps
caps87147892caps
carps96932252carps
casas75327842casas
cases75048382cases
casks115720062casks
casts77237792casts
casus76419252casus
ceps86125952ceps
clasps104512092clasps
cops86751372cops
cups85430822cups
cusps94913672cusps
damps105220412damps
daps77239162daps
dips75536912dips
dups75929512dups
eases56041612eases
easts57530322easts
eses45336102eses
espy969372espy
ess36030882es_s
fasts86429682fasts
fops96532682fops
gamps105323712gamps
gaps76042972gaps
gases65633992gases
gasp76227332gasp_
gasts66628632gasts
gawps115911012gawps
gips75632922gips
grasps9489252grasps
gyps105115022gyps
haps96443462haps
harps105926862harps
hasp96627292hasp_
hips96433702hips
hops97942632hops
hyps125418412hyps
imps86221112imps
isms66213472isms
jaups144810532jaups
keps106027302keps
kips106430512kips
kops107031292kops
lamps95624832lamps
laps66848872laps
lases54944762lases
lass47444542las_s
lasts57731262lasts
lips67141442lips
lisps76913902lisps
lops66043352lops
maps86141042maps
masas75630412masas
masks115320532masks
mass66044932mas_s
masts77035762masts
mips85534072mips
mops85940132mops
naps66238582naps
nips65830922nips
oases55330982oases
oasis56422552oasis
oasts56529182oasts
oops65232672oops
ops56641252_ops
oses46641512oses
palps94719562palps
paps86443452paps
pases75346502pases
pass65239952pas_s
pasts75936502pasts
peps85134512peps
pips85837132pips
pops86340952pops
psis68120342psis
pups86032232pups
ramps96224632ramps
raps66247732raps
rases55447212rases
rasp66029162rasp_
raspy106511702raspy
reps65937952reps
rips66237432rips
sabs66643742sabs
sacs65739072sacs
sags55948402sags
salps74423242salps
sals46851672sals
samps96124672samps
sans45153352sans
sap56463232sap_
sass45035622sass
saws75839482saws
says75942102says
sips65740102sips
sis37360542_sis
sops65244562sops
sos37761602_sos
spa55730812_spa
spas67036722_spas
spy86023742_spy
sups64834432sups
tamps95524082tamps
taps66050672taps
tarps76527112tarps
tasks94917582tasks
tass45640572tas_s
tips66436762tips
tops66248122tops
tsks86410662tsks
tups65628762tups
umps85721942umps
ups55629052_ups
urps66920472urps
uses44931112uses
vamps125415482vamps
vases84626262vases
vasts86423772vasts
waps96642082waps
warps107126422warps
wasp95626852wasp_
waspy135410992waspy
wasts87433672wasts
wisps105214182wisps
wops96634152wops
yaps95933522yaps
yaups105910742yaups
yawps13628792yawps
yeps95924402yeps
yips95226692yips
yups96121602yups
zaps156826892zaps
zeps156019342zeps
zips155723792zips

Search took 2 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.0931921408.6
2DLD Change Limit298722461.03328917.7
3Display Results2462460.0763236.8
 (SQL Overall)1786912461.202148661.4
 
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.