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

190 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
apses7682391(None) 
apes66047431ap_es
apres75426401apres
apse67725381apse_
apsis75718291apsis
arses55733871arses
asses55629281asses
lapses85217691lapses
pases75346501pases
abases85720772abases
abbes96723522abbes
ables75935542ables
abuses85119102abuses
abyes105518532abyes
aces67645092a_ces
aches106132292aches
acmes96020652acmes
acnes75922622acnes
acres76327762acres
adzes155913802adzes
aedes64625152aedes
ages55844592a_ges
agues64919052agues
aides65336602aides
aisles64721142aisles
akees96119242akees
ales47067102a_les
almes75126542almes
aloes54933672aloes
amies76837692amies
amuses85117942amuses
anes45255932a_nes
anises64826692anises
antes56334322antes
anuses66218772anuses
ape57251182ap_e_
aped78538152ap_ed
apeek114711872apeek
aper66336232ap_er
apers76629132apers
apex137220212ap_ex
apexes1539132apexes
apheses12610702apheses
aphis105917132aphis
apices104916262apices
apnea73413412apnea
apneas83211382apneas
apods86316342apods
apos65433822ap_os
appel94615892appel
appels104312792appels
apples104315762apples
apposes11511472apposes
apps86319692ap_ps
apsides103911302apsides
apter76120202apter
aptest82917512aptest
ares45871022a_res
arises65233802arises
arles56735742arles
arse46539272arse_
arsis55722422arsis
asea46327182a_sea
asepses946362asepses
ashes86230612ashes
asks85721212a_sks
aspen75216092aspen
aspens85013352aspens
asper75520432asper
aspers86220312aspers
aspis74618142aspis
aspises9611642aspises
asps65622092a_sps
ass37844062a_s_s
assess65710462assess
asset55932262asset
assets65617662assets
ates45047922a_tes
aures55137092aures
aves76142602a_ves
awes76037552a_wes
axes117337852a_xes
axises134413992axises
axles125219472axles
ayes76543512a_yes
baases85218012baases
bases75644352bases
basses85428302basses
beses75830722beses
bises75435622bises
buses75936012buses
capes95441922cap_es
carses85233652carses
cases75048382cases
causes88026472causes
copses104922472copses
coses76949492coses
daises74318982daises
doses65938502doses
eases56041612eases
elapses957662elapses
epees75219832epees
eposes84418782eposes
erses55826802erses
eses45336102_eses
esses56422972esses
fuses85628422fuses
gapes86030822gap_es
gases65633992gases
gasses75724782gasses
hanses95022632hanses
hawses125113992hawses
hoses85443172hoses
japes146322822jap_es
lapises93513462lapises
lapse74917682lapse_
lapsed94712582lapsed
lapser84113142lapser
lapsers93911052lapsers
lapsus8437272lapsus
lases54944762lases
lasses64827592lasses
leses54930812leses
loses56742012loses
lyses84518252lyses
manses84225512manses
maples104819422maples
marses84827112marses
masses85028712masses
mises74740562mises
muses75134302muses
napes74828462nap_es
nappes104515622nappes
noses55435642noses
oases55330982oases
opes65942612op_es
opuses84012242opuses
oses46641512_oses
paces96741112paces
pages85235072pages
pales75753802pales
panes76148692panes
pares77164482pares
parses85534702parses
pase65346862pase_
paseo77022512paseo
paseos88015812paseos
pashes115828392pashes
pass65239952pas_s
passe75525692passe
passes86030472passes
pastes85233912pastes
pasts75936502pasts
pates76047892pates
pauses84621472pauses
paves104833922paves
paxes144928422paxes
pees65257372_pees
pes57259782_p_es
pies66949602_pies
poses74642762poses
psis68120342_psis
puses75532202puses
pyes95528992_pyes
raises64826542raises
rapes75740722rap_es
raphes115117452raphes
rases55447212rases
rises55244042rises
roses56445772roses
ruses56136582ruses
sasses64124392sasses
sepses84515882sepses
sises55233832sises
spaes76029972spaes
spies76037622spies
spues75025382spues
tapes75838602tap_es
tapises92914012tapises
tasses64826762tasses
tawses94913192tawses
upases84112902upases
upset73222592upset
upsets8409682upsets
uses44931112_uses
valses94514612valses
vases84626262vases
vises84427772vises
wises85633192wises
yeses85119322yeses

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 Filter178691538000.500357382.0
2DLD Change Limit538001901.42337807.4
3Display Results1901900.0464130.4
 (SQL Overall)1786911901.96990752.2
 
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.