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

265 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
galatea83994(None) 
galateas937121galateas
alate55340322_alate_
alated75625142_alated
alates64833962_alates
balata8614672balat_a
galabia1038312galabia
galanga936012galanga
galaxes1538872galaxes
galea64722932gal__ea
galeate83916782galeate_
galeated104111572galeated
gallate83417122gallate_
gallates92815522gallates
galleta8399642galleta
gelate73421252gelate_
gelated93615632gelated
gelates83219582gelates
malate84624552malate_
malates93522602malates
palate84226782palate_
palates93624932palates
abate76627843_abate_
abated95918453_abated
abater85518123_abater
abates85825033_abates
ablate82219213ablate_
ablated102513443ablated
ablates92416903ablates
agalactia1253433agalactia
agate66525143_agate_
agates76121333_agates
aglare7312423aglare_
agnate73314873agnate_
agnates82813183agnates
alae45643753_ala_e_
alameda1035493_alameda
alane56135613_alane_
alaska1036713_alaska
albata839333_albat_a
alter54828503_al_ter
althea938193_althea
azalea1537003_azalea
balases93815433balases
balatas9311833balatas
barathea1345273barathea
belated103520013belated
blate75933783_blate_
calathi1247573calathi
calcanea1276273calcanea
carate84734003carate_
carates95630603carates
dealate83617843dealate_
dealated103213603dealated
dealates92716683dealates
delate73827753delate_
delated93722873delated
delates83526283delates
dilate73220693dilate_
dilated93115823dilated
dilater83515643dilater
dilates83220653dilates
egalite8311563egalite_
egalites9310503egalites
elate55335883_elate_
elated74725823_elated
elater64724203_elater
elates65032363_elates
falafel1383903falafel
falcate12311613falcate_
falcated1438473falcated
falter94519053fal_ter
folate93320393folate_
folates103218453folates
gagster9317633gagster
gaited84416923ga_ited
gaiter73819503ga_iter
gala55635163gal___a
galabias1137733galabias
galabieh1444803galabieh
galabiya1442753galabiya
galactic13106533galactic
galago838903gala_go
galagos938143galagos
galah95917623gala__h
galahs105512673gala_hs
galangal1043893galangal
galangas1046173galangas
galas65731643gala__s
galax135314463gala__x
galaxies1637163galaxies
galaxy17476313gala_xy
gale56347323gal__e_
galeae74717453gal__eae
galeas74618503gal__eas
galena74911093gal_ena
galere73716673galere_
galeres83514323galeres
gales65442483gal__es
galette84212693galette
galettes93111153galettes
galilee8312213galilee
gallanted1145893gallanted
galled84622853gal_led
gallet73630853gal_let
galletas9308133galletas
galleted1038213galleted
gallets83517403gallets
galley104215453gal_ley
gallica1047463gallica
gallied94114993gallied
gallies84122713gallies
galoped11138063galoped
galore73514843galore_
galores82614323galores
gamete9313593gamete_
gametes10312253gametes
garage8314513garage_
garaged1039253garaged
garages9314113garages
garote7717943garote_
garoted9710133garoted
garotes8614563garotes
garter74420513ga_rter
gasted84821583ga_sted
gaster75027353ga_ster
gastrea847223gastrea
gate55746573g__ate_
gateau778103g__ateau
gated75329773g__ated
gater64533643g__ater
gates65939503g__ates
gaunter82910713gaunter
gavage1137193gavage_
gavages1237683gavages
gazania1746113gazania
gelada837623gela_da
gelati73814533gelat_i
gelatin83514733gelatin
gelatis83313513gelatis
gelato73812953gelat_o
gelatos83111513gelatos
glace87420153g_lace_
glaces94218023g_laces
glade75121963g_lade_
glades84820343g_lades
glare65222953g_lare_
glared84715193g_lared
glares75518863g_lares
glaze155418163g_laze_
glazed174711773g_lazed
glazer164212263g_lazer
glazes165315643g_lazes
gloated93511533gloated
gloater83711013gloater
glute66020903g_lute_
gluteal854243g_luteal
glutei7409743g_lutei
gluten74210753g_luten
glutes74517673g_lutes
goatee73219533g_oatee
gradate9511223gradate_
gradated1157433gradated
gradates10510783gradates
grate64932883g_rate_
grated84523923g_rated
grater74625433g_rater
grates75429883g_rates
greaten83610643greaten
greater84416493greater
gyrate104912523gyrate_
gyrated12428413gyrated
gyrates113610263gyrates
halacha15388003halacha
halakha17416583halakha
halala94715093hala_la
halite93624233halite_
halites103221193halites
halted105019603hal_ted
halter94420883hal_ter
hamate113319823hamate_
hamates122917673hamates
karate105320923karate_
karates115617473karates
lanate6421263lanate_
lanated8313203lanated
late47560483__late_
lated65240673__lated
laten54328343__laten
later54843923__later
latex124717113__latex
lutea54819073__lutea
mahatma1443783mahatma
malacca1344953malacca
malanga1036663malanga
malaria9313693malaria
maleate94117543maleate_
maleates103316343maleates
malted94819853mal_ted
maltha1137503mal_tha
manatee9317663manatee
oblate82214743oblate_
oblates91913243oblates
oxalate1457623oxalate_
oxalated1695323oxalated
oxalates1557063oxalates
palabra1137183palabra
palace104516913palace_
palaced124110773palaced
palaces114216453palaces
palapa10310673pala_pa
palatal9310153palatal
palatial10410623palatial
palaver1238753palaver
palea75028663pal__ea
paleate94120003paleate_
palmate113215233palmate_
palmated132511003palmated
palpate113213923palpate_
palpated13249763palpated
palpates122613063palpates
palter84423263pal_ter
panacea1137783panacea
panatela1044913panatela
plate74635113_plate_
plateau937403_plateau
plated95225773_plated
platen84518203_platen
plater84427693_plater
plates85432243_plates
ramate83921683ramate_
relate64033633relate_
related83327573related
relater73723143relater
relates73731423relates
salted74121203sal_ted
salter64325083sal_ter
salute64418023salute_
saluted84511703saluted
saluter73512453saluter
salutes73716253salutes
savate9313783savate_
savates10312953savates
slate55438283_slate_
slated75028313_slated
slater64429183_slater
slates64934063_slates
slatey95417063_slatey
solate64526073solate_
solated83618023solated
solates73523853solates
solatia7312243solatia
talaria7412503talaria
vacate11314553vacate_
vacated1349353vacated
vacates12312833vacates
valeted1139013valeted
vallate103016563vallate_
valuate102512733valuate_
valuated12239203valuated
valuates112811193valuates
valuta938743valut_a
valvate133710813valvate_
velate93720143velate_
zapateo1844593zapateo

Search took 9 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.1561145455.1
2DLD Change Limit1340272658.42315912.0
3Display Results2652650.1102409.1
 (SQL Overall)1786912658.68920565.2
 
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.