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

208 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
galyac123597(None) 
galyacs1335271galyacs
galyak1445331galyak
calpac123211062calpac
gala55635162gal_a_
galah95917642gal_ah
galas65731642gal_as
galax135314462gal_ax
galea64722942galea_
galeae74717452galeae
galeas74618512galeas
gallic9411642gallic
galyaks1534622galyaks
gayal9312712ga_yal
kalpac14428222kalpac
agleam9158623agleam
agly86821803agly__
ala312463603_al_a_
alack114820063_al_ack
alae45643753_al_ae
alan46844083_al_an
alar46340073_al_ar
alas46358123_al_as
alba68328333_alba_
albas75925393_albas
alcaic1039983_alcaic
alec66430063_al_ec
alfa77624273_alfa_
alfas87219043_alfas
alga57927603_alga_
algae65319623_algae
algal66518223_algal
algas65624933_algas
alias55834603_alias
aliya83713483_aliya_
aliyah12397493_aliyah
aliyas93911803_aliyas
allay85620393_allay
alma66333023_alma_
almah106917253_almah
almas76629773_almas
alpaca1047383_alpaca
altar55520643_altar
alway116113923_alway
ayah108022993_a_yah
balas76937213bal_as
ballad94315323ballad
balsa77920413balsa_
balsam105612233balsam
balsas86417523balsas
banyan1139483banyan
calcar10312753calcar
calcic9311873calcic
calla74827073calla_
callan83619603callan
callas84526753callas
calpack17338333calpack
calpacs133110343calpacs
calyx17518193caly_x
celiac101910433celiac
fallacy1536433fallacy
fallal93612693fallal
gaby107123193gaby__
gaga66625553ga_ga_
gagman103811243gagman
gaily95020973gaily__
gal46055513gal___
galago838913galago
galahs105512683galahs
galaxy17476313galaxy
gale56347323gal__e
galeate83916793galeate
galena74911093galena
galenas83310343galenas
galenic1038693galenic
galere73716683galere
gales65442483gal_es
galiot72322593galiot
gall56335993gal__l
gallant83517113gallant
gallate83417133gallate
galled84622863galled
gallet73630853gallet
galley104215453galley
gallica1047463gallica
gallon73715813gallon
gallop93311383gallop
galls64729323gal_ls
gallus74313203gallus
gally95026173gal_ly
galoot72719163galoot
galop84716223gal_op
galops94712623galops
galore73514873galore
galosh1038573galosh
gals57946503gal__s
galvanic1444513galvanic
gama77035523ga_ma_
gamas85431363ga_mas
gamay116419113ga_may
gamays126310913gamays
gamba106018513gamba_
gambas115817513gambas
gamic103916203ga_mic
gamma106116103gamma_
gammas115714693gammas
gamy105427533gamy__
ganja131410003ganja_
ganjah17145503ganjah
ganjas14149113ganjas
gapy106320913gapy__
garda7316763garda_
gardai839663gardai
garlic9310043garlic
gasbag1035413gasbag
gasman92911743gasman
gateau778113gateau
gavial10310083gavial
gay76856493ga_y__
gayals1039513ga_yals
gaydar1135503gaydar
gayer94519193ga_yer
gayly124513093ga_yly
gays87338023ga_y_s
gazar154612983ga_zar
gelcap1136213gelcap
glace87420163g_l_ace
glad65624013g_l_ad
glam76529343g_l_am
gleam86916733g_leam
glean65818203g_lean
glia56423153g_lia_
glial66715433g_lial
glias64618493g_lias
gloam86015943g_loam
gloat65427683g_loat
glycan1234903g_lycan
glyph1456473g_lyph
graylag1283113graylag
guaiac946153guaiac
gulag7310823gul_ag
gular6314833gul_ar
halal85623593hal_al
hallah124115403hallah
hallal94415563hallal
halma108219253halma_
halmas117017893halmas
halva115414433halva_
halvah15499833halvah
halvas124714173halvas
halyard1476973halyard
heliac111010893heliac
ileac75814173_ileac
iliac75013493_iliac
jalap143612473jal_ap
kalam11315113kal_am
kalian10312163kalian
kalpa114512193kalpa_
kalpacs15327133kalpacs
kalpak11437243kalpak
kalpas124112943kalpas
kayak1138363ka_yak
lac510155823__l_ac
lallan63414173lallan
lilac7311073lil_ac
malar76424443mal_ar
malic94525663mal_ic
maniac103917973maniac
maya95824593ma_ya_
mayan105616903ma_yan
mayas105924383ma_yas
nala46930393nal_a_
nalas55528363nal_as
palace104516923pal_ace
palea75028663palea_
paleae84820293paleae
paleal84716673paleal
palmar104113463palmar
palpal104112053palpal
paly95835533paly__
playa105812943playa_
playact1446553playact
playas114612283playas
raya75224823ra_ya_
rayah116013503ra_yah
rayas85922053ra_yas
salaam8711013salaam
salad65321833sal_ad
salal55425703sal_al
salic73424713sal_ic
salpa75018353salpa_
salpae84614273salpae
salpas85116923salpas
salsa56718923salsa_
salsas65316133salsas
tala45938053tal_a_
talar56225383tal_ar
talas55935893tal_as
talc66226813tal__c
tambac122210243tambac
tarmac10310333tarmac
valval12398863valval
valvar12388653valvar
walla85321033walla_
wallah124011993wallah
wallas95719393wallas
waly105830903waly__
waylay1535453waylay

Search took 7 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.390458182.1
2DLD Change Limit1127162085.53020382.6
3Display Results2082080.0633301.6
 (SQL Overall)1786912085.98329866.5
 
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.