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

269 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
gaydar113550(None) 
gaydars1235801gaydars
gadder93714712gadder
gander84322762gander
garda7316762garda_
gardai839662gardai
gayal9312712gay_al
gayer94519192gay_er
gazar154612982ga_zar
mayday1535872mayday
payday1536612payday
radar61316722ra_dar
sardar73013172sardar
addax1435993_addax
adder75419593_adder
afar76720783_a_far
agar58726413_a_gar
aider65431133_aider
ajar116217703_a_jar
alar46340073_a_lar
alder65421913_alder
altar55520643_altar
anear55420323_anear
ardor64617863_ardor
attar56516693_attar
audad71511383_audad
aurar54420253_aurar
ayah108022993_ay_ah
badder103817513badder
balder95318863balder
banda85223103banda_
bandas95120543bandas
bander93928223bander
bayard124411663bay_ard
bayman133712703bayman
bazaar17306403bazaar
bazar163816003ba_zar
boyar106013763boy_ar
caesar8410933caesar
calcar10312753calcar
candor94516423candor
carder94524183carder
caudad10157673caudad
caudal91611483caudal
caviar11310163caviar
cayman133613213cayman
cedar84014323_cedar
chadar1239343chadar
cyder114611133_cyder
cymar125711263_cymar
dada66422443da_da_
dadas75819863da_das
daedal849083daedal
damar84117733da_mar
dammar11438903dammar
dander811222993dander
darbar959953darbar
daycare1355093daycare
daymare1375633daymare
daystar1143443daystar
deodar837713deodar
fader94421513fa_der
gabbard1336553gabbard
gabbart1248883gabbart
gabber114916603gabber
gad57556653ga_d__
gadded103913173gadded
gadders103611503gadders
gaddi85211633ga_ddi
gaddis94211373gaddis
gadi66329723ga_d_i
gadid85517373ga_did
gadis74825293ga_dis
gadje1457743ga_dje
gadjo1436913ga_djo
gads67843383ga_d_s
gaed66031513gaed__
gaffer134310133gaffer
gaga66625553ga_ga_
gager74726293ga_ger
gagger95016513gagger
gagman103811243gagman
gainer74117493gainer
gaiter73819503gaiter
gala55635163ga_la_
galah95917623ga_lah
galas65731643ga_las
galax135314463ga_lax
galea64722933galea_
galeae74717453galeae
galeas74618503galeas
galyac1235973galyac
galyak1445333galyak
gama77035513ga_ma_
gamas85431353ga_mas
gamay116419103ga_may
gamba106018513gamba_
gambas115817513gambas
gambir11509753gambir
gamer84928943ga_mer
gamier93617933gamier
gamma106116103gamma_
gammas115714693gammas
gammer1112318333gammer
ganders93521703ganders
ganger83721463ganger
ganja131410003ganja_
ganjah17145493ganjah
ganjas14149113ganjas
gaoler73913573gaoler
gaper86125123ga_per
gar47259903g___ar
gardant9314463gardant
garden84215083garden
garner73917003garner
garter74420513garter
gasbag1035413gasbag
gasher104320373gasher
gasman92911743gasman
gasper94515543gasper
gasser75017773gasser
gaster75027353gaster
gateau778103gateau
gater64533643ga_ter
gather104115853gather
gator64416033ga_tor
gaud67025433gaud__
gaudery1234743gaudery
gaudier938453gaudier
gauds75717723gaud_s
gaudy106611463gaud_y
gauger84714853gauger
gaur56723353ga__ur
gavial10310083gavial
gawker14559353gawker
gawper12499693gawper
gay76856493gay___
gayals1039513gayals
gayest104314333gayest
gayety13116383gayety
gayly124513093gay_ly
gays87338023gay__s
gazars164811553ga_zars
gazer155720073ga_zer
gear55934973g__ear
gelder84613713gelder
gender83517933gender
geyser1036513geyser
giddap1143413giddap
gilder84415533gilder
girder84312063girder
gladder10398313gladder
glider84614263glider
glycan1234903glycan
gnar56021383g__nar
goddam1145163goddam
goldarn944383goldarn
golder84417603golder
grader84919693grader
grammar12406893grammar
grandad1038453grandad
grandam1139393grandam
grander93315873grander
grayer106014543gray_er
graylag1283113graylag
guar56923293g__uar
guarder936463guarder
guider84313523guider
guitar7117443guitar
gular6314833g_ular
gyral94412783g_yral
haar77323493ha__ar
hadal95518123ha_dal
handax1749583handax
handcar1337373handcar
hander104526433hander
hangar104114503hangar
harder105022403harder
hayer114620243hay_er
hayward1736413hayward
heyday1635143heyday
hydra12249223_hydra
jaguar1435283jaguar
kabar114815553ka_bar
kantar10311153kantar
kayak1138363kay_ak
khaddar1642113khaddar
kyar116916843_ky_ar
ladder84617623ladder
lader65633723la_der
lahar83114263la_har
landau7310613landau
lander74028483lander
larder73720973larder
lascar868573lascar
lauder73815013lauder
layer84626473lay_er
layman113511303layman
lazar144113643la_zar
lidar6312723_lidar
maar66025053ma__ar
madam10316223ma_dam
madder103515593madder
makar115614973ma_kar
malar76424443ma_lar
maya95824583may_a_
mayan105616903may_an
mayas105924383may_as
maydays1634483maydays
mayhap1635233mayhap
mayor106616623may_or
mylar105311533_mylar
nada58022903na_da_
nadas66320813na_das
nadir61012973na_dir
navar83912733na_var
naysay1234973naysay
padder103415493padder
palmar104113463palmar
panda85022613panda_
pandas95521963pandas
pander93725523pander
pardah123412823pardah
paydays1634433paydays
payer105125723pay_er
payor105413843pay_or
phylar14437373phylar
playday1643823playday
psywar1443323psywar
qindar16317173qindar
radars71314663ra_dars
raider74318743raider
randan7315253randan
raya75224823ray_a_
rayah116013503ray_ah
rayas85922053ray_as
sadder82916973sadder
saggar84010853saggar
sambar103914163sambar
sandal73317283sandal
sandbar10108193sandbar
sander74828533sander
sangar73617683sangar
sansar63613393sansar
sardars83112903sardars
sarsar63011843sarsar
sayer84926553say_er
sirdar7269103sirdar
stylar9358113stylar
talar56225383ta_lar
tartar63214753tartar
tatar56122063ta_tar
valvar12388653valvar
vanda94515923vanda_
vandal103713833vandal
vandas103915993vandas
wadder114215483wadder
wader95325363wa_der
wander104423713wander
warder104020273warder
waylay1535453waylay
wayward1736053wayward
whydah1942953whydah
yar67253833__y_ar
yardarm13114533yardarm
yarder103813973yarder
year76534253__year
zaffar21385043zaffar
zander163417113zander

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.1731032896.0
2DLD Change Limit1127162695.89019136.8
3Display Results2692690.0763539.5
 (SQL Overall)1786912696.13929107.5
 
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.