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

275 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
galaxy1747631(None) 
galax135314461galax_
alary86123442_alary
ataxy1537312_ataxy
flaxy189012292_flaxy
gala55635162gala__
galago838912galago
galah95917642gala_h
galahs105512682galahs
galas65731642gala_s
galaxes1538882galaxes
galley104215452galley
gally95026172gal_ly
gamay116419112gama_y
glady105413942g_lady
glary96018542g_lary
glazy187410982g_lazy
malady1237862malady
salary9515212salary
aglare7312433aglare
agley96917333agl_ey
agly86821803agl__y
ala312463603_ala__
alack114820063_alack
alae45643753_ala_e
alamo7418143_alamo
alan46844083_ala_n
aland65526413_aland
alane56135613_alane
alang66023513_alang
alans55636173_alans
alant55742293_alant
alanyl955483_alanyl
alar46340073_ala_r
alarm76621423_alarm
alas46358123_ala_s
alate55340333_alate
alkoxy2033343_alkoxy
alky115920343_al_ky
allay85620393_allay
alley85721673_alley
alloy85519973_alloy
ally76935643_al_ly
alway116113923_alway
ataraxy1743983ataraxy
away108024223_awa_y
balas76937213bala_s
balata8614683balata
baldly12479833baldly
baldy115518933bal_dy
balky145418243bal_ky
ballsy11508873ballsy
bally105530103bal_ly
balmy125217473bal_my
belady12489933belady
belay105021523bela_y
braxy175410893_braxy
calami10313423calami
calash11312433calash
calix145317353calix_
calmly1337613calmly
calory11312843calory
calvary1537183calvary
calx135722793cal_x_
calyx17518193calyx_
canary11314693canary
clary105719613_clary
clay95927413_cla_y
dalasi7610623dalasi
dally95324743dal_ly
datary10310243datary
delay94820633dela_y
eutaxy1643303eutaxy
fallacy1536433fallacy
falx147120783fal_x_
flaky155715583_flaky
flamy135217473_flamy
flawy145913383_flawy
flax147325633_flax_
flay106332803_fla_y
gabby135512953ga_bby
gaby107123193g__aby
gadfly1434663gadfly
gaga66625553gaga__
gagaku1243813gagaku
gaiety10119373gaiety
gaily95020973ga_ily
gainly1049323gainly
gal46055513gal___
galabia1038333galabia
galabiya1442763galabiya
galagos938153galagos
galanga936023galanga
galatea839973galatea
galaxies1637173galaxies
gale56347323gal__e
galea64722943gal_ea
galeae74717453galeae
galeas74618513galeas
galeate83916793galeate
galena74911093galena
galere73716683galere
gales65442483gal_es
galiot72322593galiot
gall56335993gal__l
gallant83517113gallant
gallate83417133gallate
galled84622863galled
gallery11468743gallery
gallet73630853gallet
galleys11369713galleys
gallfly1433523gallfly
gallic9411643gallic
gallon73715813gallon
gallop93311383gallop
galls64729323gal_ls
gallus74313203gallus
galoot72719163galoot
galop84716223gal_op
galops94712623galops
galore73514873galore
galosh1038573galosh
gals57946503gal__s
galyac1235973galyac
galyacs1335273galyacs
galyak1445333galyak
galyaks1534623galyaks
gama77035523gama__
gamas85431363gama_s
gamays126310913gamays
gamely124711913gamely
gamey115320553ga_mey
gamily123712183gamily
gammy135514893ga_mmy
gamy105427533g__amy
gangly113911583gangly
gantry103810113gantry
gappy136212033ga_ppy
gapy106320913g__apy
garage8314513garage
garbagy1444243garbagy
garland948703garland
garvey13127873garvey
gasify1336333gasify
gassy95514023ga_ssy
gaudy106611463ga_udy
gauzy18489213ga_uzy
gavage1137193gavage
gawky16569993ga_wky
gawsy12459093ga_wsy
gay76856493g__a_y
gayal9312713gaya_l
gayals1039513gayals
gayety13116383gayety
gayly124513093ga_yly
gazabo1834833gazabo
gazar154612983gaza_r
gazars164811553gazars
gelada837623gelada
gelant72821673gelant
gelate73421263gelate
gelati73814533gelati
gelato73812963gelato
gilly94321633gil_ly
glace87420163g_lace
glad65624013g_la_d
glade75121963g_lade
gladly11497933gladly
glads75620613g_lads
glair65313553g_lair
glairy10448273glairy
glam76529343g_la_m
glams85822933g_lams
gland75217713g_land
glans65125833g_lans
glare65222963g_lare
glass65518133g_lass
glassy10527753glassy
glaze155418163g_laze
gleamy12398113gleamy
gley85724653g_l_ey
glory96413293g_lory
gluey95715263g_luey
golly95121103gol_ly
gowany13457493gowany
gramary1355913gramary
granary1157793granary
grapy115416433g_rapy
gravlax1842643gravlax_
gravy125512113g_ravy
gray85329893g_ra_y
greasy10419463greasy
guanay1037913guana_y
gulag7310823gula_g
gulags837543gulags
gular6314833gula_r
gulfy124612003gul_fy
gulley104213163gulley
gully94020683gul_ly
gulpy114612763gul_py
halal85623593hala_l
halala94715093halala
halals95018313halals
hapax1739323hapax_
inlay85214323inla_y
jalap143612473jala_p
jalaps15299183jalaps
jalopy18325863jalopy
kalam11315113kala_m
kalams12310603kalams
lacy95829633__lacy
lady86527153__lady
laky116725823__laky
lax107651523__lax_
laxly15610103__laxly
lay68865353__la_y
lazy166423073__lazy
malar76424443mala_r
malarky1645433malarky
malars85020683malars
malate84624563malate
malmy124816343mal_my
malty106721703mal_ty
milady1236613milady
nala46930393nala__
nalas55528363nala_s
onlay84212943onla_y
palace104516923palace
palais8420423palais
palapa10310673palapa
palate84226793palate
palely11311933palely
pally105727123pal_ly
palmary14338553palmary
palmy126016733pal_my
palsy105417463pal_sy
paltry114910403paltry
paly95835533pal__y
papacy1547493papacy
parlay113713993parla_y
platy105021663_platy
play95928983_pla_y
rally84725903ral_ly
ratany93411873ratany
relax124817803relax_
relay84424673rela_y
salaam8711013salaam
salably121610743salably
salad65321833sala_d
salads75316963salads
salal55425703sala_l
salals65120083salals
salami8313103salami
salify12311373salify
sally85129713sal_ly
salty85524383sal_ty
satay84718463sata_y
slaty86523153_slaty
slay76436383_sla_y
splay105816043spla_y
tala45938053tala__
talar56225383tala_r
talars66021683talars
talas55935893tala_s
talcky15294723talcky
talky126215683tal_ky
tally84526863tal_ly
unlay84613703unla_y
vagary1337333vagary
valley124311603valley
wallaby1535073wallaby
wally114625093wal_ly
waly105830903wal__y
waxy175918203__waxy
waylay1535453wayla_y

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit1127162754.80023482.5
3Display Results2752750.0932957.0
 (SQL Overall)1786912755.26633933.0
 
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.