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

219 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
gapy10632091(None) 
gaby107123191gaby
gamy105427531gamy
gap67055611gap_
gape75134511gape
gappy136212031gappy
gaps76042971gaps
gay76856491ga_y
grapy115416431grapy
aby810238062_aby
agape85614842agape
agly86821802agly
any68440492_any
ape57251182_ape
apo511142122_apo
app76827602_app
apt57352542_apt
ay511773892_a_y
baby116723682baby
bap76455842bap_
baps86040842baps
bay89661642ba_y
cagy106321992cagy
caky136222442caky
campy145116182campy
cap76758982cap_
cape87242782cape
caph116623292caph
capo85829212capo
caps87147892caps
cavy125920002cavy
cay87155982ca_y
copy116229802copy
dap66652452dap_
daps77239162daps
davy116015522davy
day76254112da_y
dopy106224152dopy
easy76224492easy
espy969372espy
fay97454862fa_y
gab67155992ga_b
gabby135512952gabby
gabs76740422gabs
gad57556652ga_d
gadi66329722gadi
gads67843382gads
gae46457702ga_e
gaed66031512gaed
gaen57329602gaen
gaes56348032gaes
gaff114828152gaff
gag57753632ga_g
gaga66625552gaga
gage65936102gage
gags66441062gags
gaily95020972gaily
gain56042162gain
gait56150192gait
gal46055512ga_l
gala55635162gala
gale56347322gale
gall56335992gall
gally95026172gally
gals57946502gals
gam67060062ga_m
gama77035522gama
gamay116419112gamay
gamb96331842gamb
game76644322game
gamey115320552gamey
gammy135514892gammy
gamp98833212gamp
gamps105323712gamps
gams76648882gams
gan48060132ga_n
gane55145302gane
gang66031972gang
gaol56925412gaol
gaped96123532gaped
gaper86125122gaper
gapes86030822gapes
gar47259902ga_r
garb75332672garb
gars55750742gars
gas48870252ga_s
gash86833022gash
gasp76227332gasp
gasps85415482gasps
gassy95514022gassy
gast56052562gast
gat46880512ga_t
gate55746572gate
gats56753442gats
gaud67025432gaud
gaudy106611462gaudy
gaum75726422gaum
gaun56427712gaun
gaur56723352gaur
gauzy18489212gauzy
gave84634052gave
gawk126716692gawk
gawky16569992gawky
gawp107618632gawp
gawps115911012gawps
gawsy12459092gawsy
gayly124513092gayly
gays87338022gays
gaze145032412gaze
gey75738302g_ey
gimpy135212232gimpy
gip67645362gip_
gips75632922gips
gipsy11579542gipsy
glady105413942glady
glary96018542glary
glazy187410982glazy
gley85724652gley
goby106021082goby
goopy115816622goopy
gory86129662gory
goy77844552g_oy
grape84824662grape
grapey126012302grapey
graph115315612graph
gravy125512112gravy
gray85329892gray
grey85624042grey
gripy115115252gripy
gulpy114612762gulpy
guppy135211272guppy
guy75728942g_uy
gyp98319012gyp_
gyps105115022gyps
gypsy14636992gypsy
hap87360052hap_
haply135915062haply
happy155813532happy
haps96443462haps
harpy136418212harpy
hay97358772ha_y
hazy1918119192hazy
heapy135914982heapy
jape134923422jape
jay136242672ja_y
kapa106021292kapa
kaph135815752kaph
kay106745542ka_y
lacy95829632lacy
lady86527152lady
laky116725822laky
lap58565272lap_
laps66848872laps
lay68865352la_y
lazy166423072lazy
many95731862many
map77255122map_
maps86141052maps
may88757632ma_y
mazy186419702mazy
mopy115721972mopy
nap56753202nap_
napa66927262napa
nape65230802nape
nappy126312332nappy
naps66238582naps
nary76931222nary
navy107518632navy
nay66952772na_y
oaky116419952oaky
pacy115328682pacy
paly95835532paly
pap76758402pap_
papa85827142papa
pappy114713802pappy
paps86443452paps
paty95234562paty
pay88461182pa_y
pipy115421512pipy
racy95825682racy
rap56261962rap_
rape65041632rape
raps66247732raps
rapt67245312rapt
raspy106511702raspy
ray66361992ra_y
ropy96323412ropy
sagy85327082sagy
sap56463232sap_
sappy125413472sappy
saps65346372saps
say67264762sa_y
soapy106114782soapy
spay96631662spay
spy86023742_spy
tap57663872tap_
tapa65129142tapa
tape64538142tape
taps66050672taps
typy126013042typy
vampy15539402vampy
vary105226062vary
wady115324992wady
waly105830902waly
wany106432362wany
wap86553372wap_
waps96642082waps
wary106740012wary
waspy135410992waspy
wavy136620472wavy
waxy175918202waxy
way96757662wa_y
yap85949822yap_
yaps95933522yaps
yay96948712ya_y
zany167316992zany
zap145840692zap_
zappy21548942zappy
zaps156826892zaps

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.266671770.7
2DLD Change Limit298722190.76638997.4
3Display Results2192190.0464760.9
 (SQL Overall)1786912191.078165761.6
 
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.