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

195 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
gateaus86632(None) 
gateau778101gateau_
gateaux1573121gateaux
bateau8810562bateau_
bateaux1693882bateaux
chateaus1345982chateaus
galeas74618502galea_s
gaseous839502gaseous
gaters74728632gate_rs
gates65939502gate__s
gateways1544602gateways
manteaus1036382manteaus
plateaus1035532plateaus
agates76121333agate__s
anears63717183_anears
areas55935773_area_s
ataps76414833_at_aps
ates45047923_ate__s
atlas55821583_atla_s
atmans84413963_atmans
atmas75721013_atma_s
attars64515313_attars
bandeaus1146503bandeaus
bates75846343bate__s
batteau936343batteau_
batteaux1742503batteaux
beaus75127113__beaus
bureaus979283bureaus
caseous9312513caseous
catechus1544813catechus
catenas9313103catenas
caterans10313203caterans
caters85336493cate_rs
cates75951873cate__s
catheads1438103catheads
catnaps1197033catnaps
caveats1239803caveats
chapeaus1544973chapeaus
chateau1236263chateau_
chateaux2043073chateaux
coteau8311083coteau_
coteaux1643713coteaux
daters74827363date_rs
dates65639153date__s
duteous838453duteous
eaters65535943eate_rs
fateful1397513fateful
fates85139233fate__s
fatheads1536763fatheads
fatuous1037783fatuous
fatwas1249053fatwa_s
gaes56348033ga_e__s
gagakus1342883gagakus
gagers84021323gage_rs
gages74529973gage__s
gaiters83516533gaite_rs
galahs105512673ga_lahs
galas65731643ga_la_s
galateas937123galatea_s
galea64722933galea__
galeae74717453galea_e
galeate83916783galeate
galenas83310333galenas
galeres83514323galeres
gales65442483gale__s
galleass935053galleass
gallous82813953gallous
gallus74313203ga_llus
galyacs1335273galyacs
galyaks1534623galyaks
gamas85431353ga_ma_s
gamays126310903ga_mays
gambas115817513gamba_s
gamelans11115843gamelans
gamers94420823game_rs
games86238553game__s
gametes10312253gametes
gammas115714693gamma_s
ganefs10489203gane_fs
ganevs10456913gane_vs
ganjahs18104003ganjahs
ganjas14149113ganja_s
gapers94520463gape_rs
gapes86030823gape__s
garters84218223garte_rs
gasbags1135473gasbags
gases65633993gase__s
gasters85624283gaste_rs
gastreas957243gastrea_s
gate55746573gate___
gated75329773gate__d
gatehouse1345163gatehouse
gateless9279953gateless
gateman1057463gateman
gatemen1047603gatemen
gatepost1145443gatepost
gater64533643gate__r
gateway1434923gateway
gathers114315063gathers
gatings95212823gatings
gators74115823gat_ors
gats56753443gat___s
gavels105911093gave_ls
gavials1136603gavials
gayals1039513ga_yals
gaydars1235803gaydars
gazars164811553ga_zars
gazebos1933493gazebos
gazers164516293gaze_rs
gazes155425913gaze__s
gears64628693g__ears
genus65319833g__enus
getas65421483get_a_s
gites65630183gite__s
gleams94812253g_leams
gleans75014743g_leans
gluteus8386253glute_us
goatees82710433goate_es
grateful1245403grateful
graters85419733grate_rs
grates75429883grate__s
greats76318393g_reats
hateful13107683hateful
haters94930393hate_rs
hates86742573hate__s
icterus936053icterus
katas95922093kat_a_s
lacteals1095663lacteals
lacteous1046773lacteous
landaus8310343landaus
lateens74210553lateens
latens64620213late_ns
latents75214313latents
laterals8312743laterals
latests73910313latests
latexes1438313latexes
luteous739273luteous
manteau937863manteau_
manteaux1742883manteaux
maters85032383mate_rs
mates75251363mate__s
mateys115610943mate_ys
matrass939393matrass
matsahs1236563matsahs
matzahs2134483matzahs
matzas1749703matza_s
naevus934593na_evus
nates55238333nate__s
oaters65029783oate_rs
oatmeals1043843oatmeals
outeats72215703outeats
paeans85118263pa_eans
pareus85420743pare_us
patens84820863pate_ns
patents94815203patents
paters84935823pate_rs
pates76047893pate__s
piteous9310683piteous
plateau937403plateau_
plateaux1742873plateaux
ratals64219583rat_als
ratans63819373rat_ans
ratbags1035763ratbags
ratels64518213rate_ls
raters63936573rate_rs
rates55352013rate__s
rattans73411953rattans
reseaus74012153reseaus
reteams9339563reteams
retears72814923retears
satays94411683sat_ays
sateens73710753sateens
sates54949323sate__s
satraps95011643satraps
steads74116223_steads
steaks104415853_steaks
steals64020063_steals
steams84916903_steams
tableaus1054843tableaus
tatars64619793tat_ars
taters64932193tate_rs
tates55444983tate__s
taus46342733__t_aus
teaks94222903__teaks
teals56234133__teals
teams75726513__teams
tears55436463__tears
teas45851493__tea_s
teats55636813__teats
uptears9106443uptears
uterus639193_uterus
vatus86114643vat__us
wataps11248683wat_aps
waterbus1345863waterbus
waters95030623wate_rs

Search took 10 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.1731032896.0
2DLD Change Limit1340271959.04614816.2
3Display Results1951950.0762565.8
 (SQL Overall)1786911959.29519224.4
 
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.