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
gateau77811(None) 
bateau8810561bateau
gateaus866331gateaus
gateaux1573121gateaux
bateaux1693882bateaux
batteau936342batteau
chateau1236272chateau
coteau8311082coteau
galea64722942galea_
galeae74717452galeae
galeas74618512galeas
gate55746572gate__
gated75329772gate_d
gateman1057472gateman
gater64533652gate_r
gaters74728642gaters
gates65939512gate_s
gateway1434932gateway
manteau937862manteau
plateau937402plateau
abeam9316533_abeam
agate66525153agate__
agates76121343agate_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
cate66254603cate__
catechu1444473catechu
catena8312483catena
catenae9311373catenae
catenas9313113catenas
cater74840723cate_r
cateran9313773cateran
caters85336503caters
cates75951893cate_s
cathead1338753cathead
catnap1098383catnap
caveat11417723caveat
chapeau1435523chapeau
chateaus1346013chateaus
chateaux2043073chateaux
coteaux1643723coteaux
couteau938833couteau
data56026653dat_a_
date56443323date__
dated75530993date_d
dater65332313date_r
daters74827373daters
dates65639153date_s
eaten55323053eate_n
eater54639843eate_r
eaters65535953eaters
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
gagers84021333gagers
gages74529973gage_s
gagman103811243gagman
gaiety10119373gaiety
gaited84416923gaite_d
gaiter73819503gaite_r
gaiters83516543gaiters
gala55635163ga_la_
galah95917643ga_lah
galas65731643ga_las
galatea839973galatea_
galateas937153galateas
galax135314463ga_lax
gale56347323gale__
galeate83916793galeate
galena74911093galena
galenas83310343galenas
galere73716683galere
gales65442483gale_s
galyac1235973galyac
galyak1445333galyak
gama77035523ga_ma_
gamas85431363ga_mas
gamay116419113ga_may
gamba106018513gamba_
gambas115817513gambas
game76644323game__
gamed95126393game_d
gamelan10106643gamelan
gamely124711913gamely
gamer84928943game_r
gamers94420833gamers
games86238553game_s
gamest94919933gamest
gametal1037603gametal
gamete9313593gamete
gamey115320553game_y
gamma106116103gamma_
gammas115714693gammas
gane55145303gane__
ganef96322463gane_f
ganefs10489203ganefs
ganev95513863gane_v
ganevs10456913ganevs
ganja131410003ganja_
ganjah17145503ganjah
ganjas14149113ganjas
gape75134513gape__
gaped96123533gape_d
gaper86125123gape_r
gapers94520473gapers
gapes86030823gape_s
garda7316763garda_
gardai839663gardai
garter74420513garte_r
garters84218233garters
gasbag1035413gasbag
gaseous839503gaseous
gases65633993gase_s
gasman92911743gasman
gasted84821583gaste_d
gaster75027353gaste_r
gasters85624293gasters
gastral8329553gastral
gastrea847243gastrea_
gastreas957263gastreas
gat46880513gat___
gatemen1047603gatemen
gateways1544613gateways
gather104115863gather
gathers114315073gathers
gating84826953gating
gator64416043gat_or
gators74115843gators
gats56753443gat__s
gave84634053gave__
gavel95815183gave_l
gavels105911093gavels
gavial10310083gavial
gayal9312713ga_yal
gaydar1135503gaydar
gayer94519193gaye_r
gayest104314333gayest
gayety13116383gayety
gazar154612983ga_zar
gaze145032413gaze__
gazebo1833673gazebo
gazed165520333gaze_d
gazer155720073gaze_r
gazers164516303gazers
gazes155425913gaze_s
gear55934973g__ear
genu55929073g__enu
geta56627443get_a_
getas65421483get_as
gite55438613gite__
gites65630183gite_s
gleam86916733g_leam
glean65818203g_lean
gluteal854243gluteal
gnathal1144353gnathal
goatee73219533goate_e
goateed9307063goateed
goatees82710443goatees
grate64932883grate__
grated84523923grate_d
grateful1245403grateful
grater74625443grate_r
graters85419743graters
grates75429893grate_s
great66034243g_reat
gutta64613383gutta_
guttae73210583guttae
haleru94212073haleru
hate78450173hate__
hated95734023hate_d
hateful13107683hateful
hater85034753hate_r
haters94930403haters
hates86742573hate_s
jambeau1843773jambeau
kata85626023kat_a_
katas95922093kat_as
lacteal966823lacteal
lactean956483lactean
landau7310613landau
late47560483late__
lated65240673late_d
lateen64014863lateen
lately93413843lately
laten54328343late_n
latens64620213latens
latent64124303latent
later54843923late_r
laterad8310843laterad
lateral7313573lateral
latest63822703latest
latex124717113late_x
latu47934183lat__u
lutea54819073lutea_
luteal64411483luteal
manteaus1036383manteaus
manteaux1742883manteaux
mate65154223mate__
mated85537783mate_d
mater74438863mate_r
maters85032393maters
mates75251363mate_s
matey107022663mate_y
mateys115610943mateys
matsah1138233matsah
matza16311813matza_
matzah2035963matzah
matzas1749703matzas
natal53921493nat_al
nates55238333nate_s
oaten55222403oate_n
oater55433733oate_r
oaters65029793oaters
oatmeal944973oatmeal
osteal6312963osteal
outeat62824533outeat
paean77222723pa_ean
palea75028663palea_
paleae84820293paleae
paleal84716673paleal
pareu74928743pare_u
pate65350463pate__
pated85237843pate_d
paten74827343pate_n
patens84820863patens
patent84524923patent
pater74740723pate_r
paters84935833paters
pates76047893pate_s
plateaus1035533plateaus
plateaux1742873plateaux
ratal55025113rat_al
ratan53722663rat_an
ratbag956563ratbag
rate45458763rate__
rated65441383rate_d
ratel54224883rate_l
ratels64518213ratels
rater54943283rate_r
raters63936583raters
rates55352013rate_s
rattan63613603rattan
reseau64216213reseau
reteam83214533reteam
retear63115483retear
satay84718463sat_ay
sate45556103sate__
sated66238533sate_d
sateen63815013sateen
satem76021463sate_m
sates54949323sate_s
satrap86212553satrap
stead65520273_stead
steak95219803_steak
steal56125473_steal
steam76322933_steam
tableau966283tableau
tatar56122063tat_ar
tate44748603tate__
tater54138613tate_r
taters64932203taters
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
waters95030633waters
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.406440125.6
2DLD Change Limit1127163165.75019602.8
3Display Results3163160.1062981.1
 (SQL Overall)1786913166.26228535.8
 
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.