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

316 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
gateau77810(None) 
bateau8810561bateau
gateaus866321gateaus
gateaux1573121gateaux
bateaux1693882bateaux
batteau936342batteau
chateau1236262chateau
coteau8311082coteau
galea64722932galea_
galeae74717452galeae
galeas74618502galeas
gate55746572gate__
gated75329772gate_d
gateman1057462gateman
gater64533642gate_r
gaters74728632gaters
gates65939502gate_s
gateway1434922gateway
manteau937862manteau
plateau937402plateau
abeam9316533_abeam
agate66525143agate__
agates76121333agate_s
agleam9158623agleam
ahead96817053_ahead
anear55420323_anear
apeak115513453_apeak
area45843393_area_
areae55229743_areae
areal55928733_areal
areas55935773_areas
asea46327183_asea_
atap66722453_at_ap
ate37059243_ate__
ates45047923_ate_s
atlas55821583_atlas
atma68121773_atma_
atman75520143_atman
atmas75721013_atmas
attar56516693_attar
bandeau1038523bandeau
bate66552423bate__
bated85935533bate_d
bates75846343bate_s
batman105214063batman
batteaux1742503batteaux
battu75216613bat_tu
beau66137273__beau
bureau8712523bureau
cate66254593cate__
catechu1444473catechu
catena8312473catena
catenae9311363catenae
catenas9313103catenas
cater74840703cate_r
cateran9313763cateran
caters85336493caters
cates75951873cate_s
cathead1338753cathead
catnap1098383catnap
caveat11417723caveat
chapeau1435523chapeau
chateaus1345983chateaus
chateaux2043073chateaux
coteaux1643713coteaux
couteau938813couteau
data56026653dat_a_
date56443323date__
dated75530993date_d
dater65332313date_r
daters74827363daters
dates65639153date_s
eaten55323053eate_n
eater54639843eate_r
eaters65535943eaters
eatery95316353eatery
eau37450943___eau
fatal84819373fat_al
fate75444283fate__
fated95632133fate_d
fateful1397513fateful
fates85139233fate_s
fathead1437863fathead
fatwa1168063fatwa_
fatwas1249053fatwas
gae46457703ga_e__
gaed66031513ga_e_d
gaen57329603ga_e_n
gaes56348033ga_e_s
gaga66625553ga_ga_
gagaku1243813gagaku
gage65936103gage__
gaged85522313gage_d
gager74726293gage_r
gagers84021323gagers
gages74529973gage_s
gagman103811243gagman
gaiety10119373gaiety
gaited84416923gaite_d
gaiter73819503gaite_r
gaiters83516533gaiters
gala55635163ga_la_
galah95917623ga_lah
galas65731643ga_las
galatea839943galatea_
galateas937123galateas
galax135314463ga_lax
gale56347323gale__
galeate83916783galeate
galena74911093galena
galenas83310333galenas
galere73716673galere
gales65442483gale_s
galyac1235973galyac
galyak1445333galyak
gama77035513ga_ma_
gamas85431353ga_mas
gamay116419103ga_may
gamba106018513gamba_
gambas115817513gambas
game76644323game__
gamed95126393game_d
gamelan10106643gamelan
gamely124711913gamely
gamer84928943game_r
gamers94420823gamers
games86238553game_s
gamest94919923gamest
gametal1037603gametal
gamete9313593gamete
gamey115320553game_y
gamma106116103gamma_
gammas115714693gammas
gane55145293gane__
ganef96322463gane_f
ganefs10489203ganefs
ganev95513863gane_v
ganevs10456913ganevs
ganja131410003ganja_
ganjah17145493ganjah
ganjas14149113ganjas
gape75134513gape__
gaped96123533gape_d
gaper86125123gape_r
gapers94520463gapers
gapes86030823gape_s
garda7316763garda_
gardai839663gardai
garter74420513garte_r
garters84218223garters
gasbag1035413gasbag
gaseous839503gaseous
gases65633993gase_s
gasman92911743gasman
gasted84821583gaste_d
gaster75027353gaste_r
gasters85624283gasters
gastral8329553gastral
gastrea847223gastrea_
gastreas957243gastreas
gat46880513gat___
gatemen1047603gatemen
gateways1544603gateways
gather104115853gather
gathers114315063gathers
gating84826953gating
gator64416033gat_or
gators74115823gators
gats56753443gat__s
gave84634053gave__
gavel95815183gave_l
gavels105911093gavels
gavial10310083gavial
gayal9312713ga_yal
gaydar1135503gaydar
gayer94519193gaye_r
gayest104314333gayest
gayety13116383gayety
gazar154612983ga_zar
gaze145032413gaze__
gazebo1833673gazebo
gazed165520333gaze_d
gazer155720073gaze_r
gazers164516293gazers
gazes155425913gaze_s
gear55934973g__ear
genu55929073g__enu
geta56627443get_a_
getas65421483get_as
gite55438613gite__
gites65630183gite_s
gleam86916733g_leam
glean65818203g_lean
gluteal854243gluteal
gnathal1144353gnathal
goatee73219533goate_e
goateed9307063goateed
goatees82710433goatees
grate64932883grate__
grated84523923grate_d
grateful1245403grateful
grater74625433grate_r
graters85419733graters
grates75429883grate_s
great66034243g_reat
gutta64613383gutta_
guttae73210583guttae
haleru94212073haleru
hate78450173hate__
hated95734023hate_d
hateful13107683hateful
hater85034753hate_r
haters94930393haters
hates86742573hate_s
jambeau1843773jambeau
kata85626023kat_a_
katas95922093kat_as
lacteal966813lacteal
lactean956473lactean
landau7310613landau
late47560483late__
lated65240673late_d
lateen64014863lateen
lately93413843lately
laten54328343late_n
latens64620213latens
latent64124303latent
later54843923late_r
laterad8310833laterad
lateral7313563lateral
latest63822703latest
latex124717113late_x
latu47934183lat__u
lutea54819073lutea_
luteal64411483luteal
manteaus1036383manteaus
manteaux1742883manteaux
mate65154213mate__
mated85537783mate_d
mater74438863mate_r
maters85032383maters
mates75251363mate_s
matey107022663mate_y
mateys115610943mateys
matsah1138233matsah
matza16311813matza_
matzah2035963matzah
matzas1749703matzas
natal53921493nat_al
nates55238333nate_s
oaten55222403oate_n
oater55433733oate_r
oaters65029783oaters
oatmeal944973oatmeal
osteal6312953osteal
outeat62824533outeat
paean77222723pa_ean
palea75028663palea_
paleae84820293paleae
paleal84716673paleal
pareu74928743pare_u
pate65350463pate__
pated85237843pate_d
paten74827343pate_n
patens84820863patens
patent84524923patent
pater74740723pate_r
paters84935823paters
pates76047893pate_s
plateaus1035533plateaus
plateaux1742873plateaux
ratal55025113rat_al
ratan53722663rat_an
ratbag956563ratbag
rate45458763rate__
rated65441383rate_d
ratel54224883rate_l
ratels64518213ratels
rater54943283rate_r
raters63936573raters
rates55352013rate_s
rattan63613603rattan
reseau64216213reseau
reteam83214533reteam
retear63115483retear
satay84718463sat_ay
sate45556103sate__
sated66238533sate_d
sateen63815013sateen
satem76021453sate_m
sates54949323sate_s
satrap86212553satrap
stead65520273_stead
steak95219803_steak
steal56125473_steal
steam76322923_steam
tableau966273tableau
tatar56122063tat_ar
tate44748603tate__
tater54138613tate_r
taters64932193taters
tates55444983tate_s
tau36856903__t_au
tea37353323__tea_
teak85930843__teak
teal45546503__teal
team66238653__team
tear45242883__tear
teas45851493__teas
teat45963633__teat
uptear896783uptear
vatu76524333vat__u
watap102111673wat_ap
water84733313wate_r
waters95030623waters
watery123914493watery

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.1261418182.5
2DLD Change Limit1127163166.26317997.1
3Display Results3163160.0963291.7
 (SQL Overall)1786913166.48527554.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.