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

220 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
gaydars123580(None) 
gaydar1135501gaydar_
gadders103611502gadders
ganders93521702ganders
gayals1039512gay_als
gazars164811552ga_zars
maydays1634492maydays
paydays1634432paydays
radars71314672ra_dars
sardars83112902sardars
adders84315703_adders
afars85716513_a_fars
agars66120643_a_gars
aiders74524633_aiders
alders74218423_alders
altars64518153_altars
anears63717183_anears
ardors74416873_ardors
attars64515313_attars
audads8167103_audads
ayahs116813523_ay_ahs
badass949293ba_dass
bandas95120543banda_s
banders104324563banders
bayard124411663bay_ard
bayards13379683bay_ards
bazaars18275883bazaars
bazars174613113ba_zars
boyars115611983boy_ars
caesars9410733caesars
calcars11312653calcars
candors104216763candors
carders104820353carders
caviars1238623caviars
caymans14349513caymans
cedars93312833_cedars
chadars1338293chadars
cyders12398833_cyders
cymars13599153_cymars
dadas75819863da_da_s
damars93814993da_mars
dammars12308193dammars
danders93921183danders
darbars10510093darbars
daycare1355093daycare
daycares1454803daycares
daymare1375633daymare
daymares1445333daymares
daystars1243903daystars
deodars937623deodars
faders105117463fa_ders
gabbard1336553gabbard
gabbards1445753gabbards
gabbart1248883gabbart
gabbarts1344063gabbarts
gabbers124612833gabbers
gadder93714713gadder_
gaddis94211373ga_ddis
gadids95611823ga_dids
gadis74825293ga_d_is
gads67843383ga_d__s
gaffers14428713gaffers
gagers84021333ga_gers
gaggers103413663gaggers
gainers84214593gainers
gaiters83516543gaiters
galahs105512673ga_lahs
galas65731643ga_la_s
galeas74618513galea_s
galyacs1335273galyacs
galyaks1534623galyaks
gamas85431363ga_ma_s
gamays126310913ga_mays
gambas115817513gamba_s
gambirs12359083gambirs
gamers94420833ga_mers
gammas115714693gamma_s
gammers123214563gammers
gander84322763gander_
gangers94418603gangers
ganjahs18104003ganjahs
ganjas14149113ganja_s
gaolers83511563gaolers
gapers94520473ga_pers
garda7316763garda__
gardai839663garda_i
gardant9314463gardant
gardens93312093gardens
garners83815983garners
gars55750743g___ars
garters84218233garters
gasbags1135473gasbags
gaspers105014133gaspers
gassers84714633gassers
gasters85624293gasters
gateaus866333gateaus
gaters74728643ga_ters
gathers114315073gathers
gators74115833ga_tors
gaudery1234743gaudery
gaudies9311973gaudies
gauds75717723gaud__s
gaugers94211713gaugers
gaurs66317993ga__urs
gavials1136603gavials
gawkers15347453gawkers
gawpers13448313gawpers
gayal9312713gay_a_l
gayer94519193gay_er_
gayness1136843gayness
gays87338023gay___s
gazar154612983ga_zar_
gazers164516303ga_zers
gears64628693g__ears
gelders93812573gelders
genders93616783genders
geysers1135703geysers
gilders94212463gilders
girders9379943girders
glanders103811503glanders
gliders94811843gliders
glycans1344233glycans
gnars66718853g__nars
goddams1233983goddams
goldarn944383goldarn
goldarns1043593goldarns
graders94716013graders
grammars13345943grammars
grandads1136553grandads
grandams1237123grandams
graylags1372983graylags
guarders1035883guarders
guars65021053g__uars
guiders94111113guiders
guitars8116863guitars
haars85620473ha__ars
handcars1437623handcars
handers114224333handers
hangars114313493hangars
hardass1139753hardass
hayers124415943hay_ers
hayward1736413hayward
haywards1845873haywards
heydays1734143heydays
hydras13239313_hydras
jaguars1535233jaguars
kabars124513953ka_bars
kantars11310033kantars
kayaks1236333kay_aks
khaddars1741993khaddars
kyars124813963_ky_ars
ladders94115173ladders
laders74927763la_ders
lahars94013163la_hars
landaus8310343landaus
landers84026213landers
larders83516943larders
lascars979013lascars
lauders84012893lauders
layers93921183lay_ers
lazars153812393la_zars
lidars7310783_lidars
maars74621633ma__ars
madams11310943ma_dams
madders113513213madders
madras94316433ma_dras
makars124612633ma_kars
malars85020683ma_lars
mayas105924383may_a_s
mayday1535883mayda_y
mayors115714193may_ors
mylars114310443_mylars
nadas66320813na_da_s
nadirs7109003na_dirs
navars92810573na_vars
naysays1344123naysays
padders113312873padders
pandas95521963panda_s
panders103423733panders
pardahs13289673pardahs
payday1536613payda_y
payers114621823pay_ers
payors114312643pay_ors
playdays1742973playdays
psywars1533673psywars
qindars17267423qindars
radar61316723ra_dar_
raiders84615143raiders
randans8313213randans
rayahs12579193ray_ahs
rayas85922053ray_a_s
saggars93610683saggars
sambars115113843sambars
sandals82715203sandals
sandbars11108783sandbars
sanders84025943sanders
sangars83116253sangars
sansars73313913sansars
sardar73013173sardar_
sarsars73512143sarsars
sayers94221593say_ers
sirdars8228213sirdars
talars66021683ta_lars
tartars73313403tartars
tatars64619793ta_tars
vandals113211663vandals
vandas103915993vanda_s
wadders123812443wadders
waders109120643wa_ders
wanders114221333wanders
warders113416813warders
waylays1634673waylays
wayward1736053wayward
whydahs2041883whydahs
yardarm13114533yardarm
yardarms14123333yardarms
yarders113211593yarders
years84527673__years
zaffars22325233zaffars
zanders173015793zanders

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272206.08022043.9
3Display Results2202200.0762894.7
 (SQL Overall)1786912206.56227231.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.